APPS.PAY_FR_ARC_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 2139: from pay_external_accounts pxa

2135: select bank.meaning bank_name
2136: ,substr(pxa.segment2, 1, 5) bank_code
2137: ,substr(pxa.segment3, 1, 5) branch_code
2138: ,substr(pxa.segment5, 1, 14) account_number
2139: from pay_external_accounts pxa
2140: ,hr_lookups bank
2141: where bank.lookup_type(+) = 'FR_BANK'
2142: and bank.lookup_code(+) = pxa.segment1
2143: and pxa.external_account_id = p_account_id;