APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2569: FROM pay_personal_payment_methods_f ppm

2565: ------------
2566: /* Cursor to check if bank details are attached with ppm */
2567: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
2568: SELECT ppm.external_account_id
2569: FROM pay_personal_payment_methods_f ppm
2570: WHERE ppm.personal_payment_method_id = p_ppm_id
2571: AND p_date_earned BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
2572:
2573: -------------

Line 2611: pay_personal_payment_methods_f ppm,

2607: ppttl.payment_type_name pay_type,
2608: ppp.value value
2609: FROM pay_external_accounts pea,
2610: pay_org_payment_methods_f pop,
2611: pay_personal_payment_methods_f ppm,
2612: pay_assignment_actions paa,
2613: pay_payment_types ppt,
2614: pay_payment_types_tl ppttl,
2615: pay_pre_payments ppp