DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PAY_EXTERNAL_ACCOUNTS

Line 2957: from pay_external_accounts pea,

2953: -- pea.segment1 branch_code,
2954: pea.segment4 acc_holder_name,
2955: pea.segment6 acc_holder_reln,
2956: p_payment_type account_type
2957: from pay_external_accounts pea,
2958: pay_personal_payment_methods_f ppm
2959: where ppm.assignment_id = P_ASG_ID
2960: and ppm.personal_payment_method_id = P_PAY_METHOD_ID
2961: and ppm.external_account_id = pea.external_account_id

Line 2978: pay_external_accounts pea

2974: pea.segment4 acc_holder_name,
2975: pea.segment6 acc_holder_reln,
2976: ppm.ppm_information1 account_type
2977: from pay_personal_payment_methods_f ppm,
2978: pay_external_accounts pea
2979: where ppm.assignment_id = P_ASG_ID
2980: and ppm.external_account_id = pea.external_account_id(+)
2981: and ppm.ppm_information_category in ('ZA_ACB','ZA_CHEQUE','ZA_CREDIT TRANSFER','ZA_MANUAL PAYMENT')
2982: and ppm.ppm_information1 in ('Y','0','7')