APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_PRE_PAYMENTS

Line 2551: FROM pay_pre_payments

2547: /* Cursor to fetch ppm and opm ids to check which payment method to archive */
2548: CURSOR csr_chk(p_prepay_assact_id NUMBER) IS
2549: SELECT personal_payment_method_id ppm_id,
2550: org_payment_method_id opm_id
2551: FROM pay_pre_payments
2552: WHERE assignment_action_id = p_prepay_assact_id;
2553:
2554: ------------
2555: /* Cursor to check if bank details are attached with ppm */

Line 2573: pay_pre_payments ppp

2569: FROM pay_org_payment_methods_f pop,
2570: pay_assignment_actions paa,
2571: pay_payment_types ppt,
2572: pay_payment_types_tl ppttl,
2573: pay_pre_payments ppp
2574: WHERE paa.assignment_action_id = p_prepay_assact_id
2575: AND ppt.payment_type_id = pop.payment_type_id
2576: AND ppt.payment_type_id = ppttl.payment_type_id
2577: AND ppttl.language = userenv('LANG')

Line 2604: pay_pre_payments ppp

2600: pay_personal_payment_methods_f ppm,
2601: pay_assignment_actions paa,
2602: pay_payment_types ppt,
2603: pay_payment_types_tl ppttl,
2604: pay_pre_payments ppp
2605: WHERE
2606: -- pea.id_flex_num=20 AND
2607: pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
2608: AND paa.assignment_action_id = p_prepay_assact_id