APPS.PAY_ZA_EOY_VAL dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2958: pay_personal_payment_methods_f ppm

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
2962: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;

Line 2977: from pay_personal_payment_methods_f ppm,

2973: pea.segment3 sars_acc_no,
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')

Line 2996: from pay_personal_payment_methods_f

2992: l_warn_count := P_EE_WARN_TAB.count;
2993:
2994: select count(*)
2995: into l_count
2996: from pay_personal_payment_methods_f
2997: where assignment_id = P_ASG_ID
2998: and PPM_INFORMATION_CATEGORY in ('ZA_ACB','ZA_CHEQUE','ZA_CREDIT TRANSFER','ZA_MANUAL PAYMENT')
2999: and ppm_information1 in ('Y','0','7')
3000: and p_effective_date between effective_start_date and effective_end_date;