APPS.PAY_KW_ARCHIVE dependencies on PAY_PRE_PAYMENTS

Line 1496: FROM pay_pre_payments

1492: /* Cursor to fetch ppm and opm ids to check which payment method to archive */
1493: CURSOR csr_chk(p_prepay_assact_id NUMBER) IS
1494: SELECT personal_payment_method_id ppm_id,
1495: org_payment_method_id opm_id
1496: FROM pay_pre_payments
1497: WHERE assignment_action_id = p_prepay_assact_id;
1498:
1499: /* Cursor to check if bank details are attached with ppm */
1500: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS

Line 1525: pay_pre_payments ppp

1521: FROM pay_org_payment_methods_f pop,
1522: pay_assignment_actions paa,
1523: pay_payment_types ppt,
1524: pay_payment_types_tl ppttl,
1525: pay_pre_payments ppp
1526: WHERE paa.assignment_action_id = p_prepay_assact_id
1527: AND ppt.payment_type_id = pop.payment_type_id
1528: AND ppt.payment_type_id = ppttl.payment_type_id
1529: AND ppttl.language = userenv('LANG')

Line 1554: pay_pre_payments ppp

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
1555: WHERE pea.id_flex_num=p_flex_num
1556: AND pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1557: AND paa.assignment_action_id = p_prepay_assact_id
1558: AND paa.assignment_id = ppm.assignment_id