DBA Data[Home] [Help]

APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 2716: , pay_external_accounts pea

2712: 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz- ,''')) bank_branch_name
2713: , substr(pea.segment4,1,50) ac_holder_name -- account holder name
2714: , pea.segment6 ac_holder_relation-- account holder relationship
2715: from PAY_PERSONAL_PAYMENT_METHODS_F PPM
2716: , pay_external_accounts pea
2717: , pay_za_branch_cdv_details bnk
2718: where PPM.PERSONAL_PAYMENT_METHOD_ID = p_personal_pay_method_id
2719: and PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID
2720: and bnk.branch_code = pea.segment1