APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 271: FROM pay_personal_payment_methods_f ppm

267:
268: CURSOR csr_get_payee_type_id
269: IS
270: SELECT payee_type,payee_id
271: FROM pay_personal_payment_methods_f ppm
272: WHERE ppm.assignment_id = p_assignment_id
273: AND ppm.personal_payment_method_id = p_per_pay_method_id
274: AND p_date_earned BETWEEN ppm.effective_start_date AND ppm.effective_end_date
275: AND ppm.business_group_id = p_business_group_id

Line 278: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;

274: AND p_date_earned BETWEEN ppm.effective_start_date AND ppm.effective_end_date
275: AND ppm.business_group_id = p_business_group_id
276: AND ppm.payee_id is NOT NULL;
277: --
278: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
279: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
280: l_payee_name VARCHAR(35);
281: l_org_count NUMBER;
282: --

Line 279: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;

275: AND ppm.business_group_id = p_business_group_id
276: AND ppm.payee_id is NOT NULL;
277: --
278: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
279: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
280: l_payee_name VARCHAR(35);
281: l_org_count NUMBER;
282: --
283:

Line 494: ,pay_personal_payment_methods_f ppmf

490: ,pay_all_payrolls_f ppf
491: ,pay_pre_payments ppp
492: ,pay_assignment_actions paa
493: ,pay_payroll_actions ppa
494: ,pay_personal_payment_methods_f ppmf
495: ,pay_external_accounts pea
496: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
497: AND paa.pre_payment_id = ppp.pre_payment_id
498: AND paa.payroll_action_id = ppa.payroll_action_id