DBA Data[Home] [Help]

APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PAY_ZA_BRANCH_CDV_DETAILS

Line 2717: , pay_za_branch_cdv_details bnk

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
2721: and l_effective_date between PPM.effective_start_date and PPM.effective_end_date ;