APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_PRE_PAYMENTS

Line 2562: FROM pay_pre_payments

2558: /* Cursor to fetch ppm and opm ids to check which payment method to archive */
2559: CURSOR csr_chk(p_prepay_assact_id NUMBER) IS
2560: SELECT personal_payment_method_id ppm_id,
2561: org_payment_method_id opm_id
2562: FROM pay_pre_payments
2563: WHERE assignment_action_id = p_prepay_assact_id;
2564:
2565: ------------
2566: /* Cursor to check if bank details are attached with ppm */

Line 2584: pay_pre_payments ppp

2580: FROM pay_org_payment_methods_f pop,
2581: pay_assignment_actions paa,
2582: pay_payment_types ppt,
2583: pay_payment_types_tl ppttl,
2584: pay_pre_payments ppp
2585: WHERE paa.assignment_action_id = p_prepay_assact_id
2586: AND ppt.payment_type_id = pop.payment_type_id
2587: AND ppt.payment_type_id = ppttl.payment_type_id
2588: AND ppttl.language = userenv('LANG')

Line 2615: pay_pre_payments ppp

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
2616: WHERE
2617: -- pea.id_flex_num=20 AND
2618: pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
2619: AND paa.assignment_action_id = p_prepay_assact_id