APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1387: FROM pay_personal_payment_methods_f ppm

1383: WHERE assignment_action_id = p_prepay_assact_id;
1384: /* Cursor to check if bank details are attached with ppm */
1385: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1386: SELECT ppm.external_account_id
1387: FROM pay_personal_payment_methods_f ppm
1388: WHERE ppm.personal_payment_method_id = p_ppm_id
1389: AND p_date_earned BETWEEN ppm.effective_start_date
1390: AND ppm.effective_end_date;
1391: /* Cursor to retrieve Organization Payment Method Information */

Line 1424: pay_personal_payment_methods_f ppm,

1420: ppttl.payment_type_name pay_type,
1421: ppp.value value
1422: FROM pay_external_accounts pea,
1423: pay_org_payment_methods_f pop,
1424: pay_personal_payment_methods_f ppm,
1425: pay_assignment_actions paa,
1426: pay_payment_types ppt,
1427: pay_payment_types_tl ppttl,
1428: pay_pre_payments ppp