APPS.PAY_KW_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1502: FROM pay_personal_payment_methods_f ppm

1498:
1499: /* Cursor to check if bank details are attached with ppm */
1500: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1501: SELECT ppm.external_account_id
1502: FROM pay_personal_payment_methods_f ppm
1503: WHERE ppm.personal_payment_method_id = p_ppm_id
1504: AND p_date_earned BETWEEN ppm.effective_start_date
1505: AND ppm.effective_end_date;
1506:

Line 1550: pay_personal_payment_methods_f ppm,

1546: ppttl.payment_type_name pay_type,
1547: ppp.value value
1548: FROM pay_external_accounts pea,
1549: pay_org_payment_methods_f pop,
1550: pay_personal_payment_methods_f ppm,
1551: pay_assignment_actions paa,
1552: pay_payment_types ppt,
1553: pay_payment_types_tl ppttl,
1554: pay_pre_payments ppp