APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_PRE_PAYMENTS

Line 1382: FROM pay_pre_payments

1378: /* Cursor to fetch ppm and opm ids to check which payment method to archive */
1379: CURSOR csr_chk(p_prepay_assact_id NUMBER) IS
1380: SELECT personal_payment_method_id ppm_id,
1381: org_payment_method_id opm_id
1382: FROM pay_pre_payments
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

Line 1401: pay_pre_payments ppp

1397: FROM pay_org_payment_methods_f pop,
1398: pay_assignment_actions paa,
1399: pay_payment_types ppt,
1400: pay_payment_types_tl ppttl,
1401: pay_pre_payments ppp
1402: WHERE paa.assignment_action_id = p_prepay_assact_id
1403: AND ppt.payment_type_id = pop.payment_type_id
1404: AND ppt.payment_type_id = ppttl.payment_type_id
1405: AND ppttl.language = userenv('LANG')

Line 1428: pay_pre_payments ppp

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
1429: WHERE pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1430: AND paa.assignment_action_id = p_prepay_assact_id
1431: AND paa.assignment_id = ppm.assignment_id
1432: AND ppm.org_payment_method_id = pop.org_payment_method_id