Hi,

I am trying to produce a query that brings back an employee and their payment details, including their bank details.

I am having trouble finding which table contains their bank name. I have found all the other bank information (sort code, account number etc..) in PAY_EXTERNAL_ACCOUNTS, but SEGMENT1 contains a number. Does this link to another table contain the Bank Names?

When you enter the bank details via the application, in the GB BANK DETAILS form there is a full list of all the UK Bank Names, but I cannot find this information in the tables.

I have checked in PAY_BANK_BRANCHES and there are only two entries in this table.

Any help would be appreciated.

Many Thanks

Martin

Hello Martin

Bank name is held as a lookup in FND_LOOKUP_VALUES. Lookup type is 'GB_BANKS' I think, and the MEANING value represents the actual name of the bank.

Hope this helps.

Welcome to the forum by the way.

Thanks CT, this has worked.

Thanks Again

Martin