APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2696: from pay_personal_payment_methods_f

2692: --Added for ER 9387986
2693: cursor csr_asg_bank_ddf (p_assignment_id number, l_effective_date date) is
2694: select personal_payment_method_id personal_pay_method_id
2695: , ppm_information1 account_type
2696: from pay_personal_payment_methods_f
2697: where assignment_id = p_assignment_id
2698: and PPM_INFORMATION_CATEGORY in ('ZA_ACB','ZA_CHEQUE','ZA_CREDIT TRANSFER','ZA_MANUAL PAYMENT')
2699: and ppm_information1 in ('Y','0','7')
2700: and l_effective_date between effective_start_date and effective_end_date;

Line 2715: from PAY_PERSONAL_PAYMENT_METHODS_F PPM

2711: 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz- ,''0123456789~%^&*<>{}[]"\/?@&$!#+=;:().',
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