APPS.PAY_DK_ARCHIVE dependencies on PAY_PRE_PAYMENTS

Line 1638: FROM pay_pre_payments

1634: /* Cursor to fetch ppm and opm ids to check which payment method to archive */
1635: CURSOR csr_chk(p_prepay_assact_id NUMBER) IS
1636: SELECT personal_payment_method_id ppm_id,
1637: org_payment_method_id opm_id
1638: FROM pay_pre_payments
1639: WHERE assignment_action_id = p_prepay_assact_id;
1640:
1641: ------------
1642: /* Cursor to check if bank details are attached with ppm */

Line 1659: pay_pre_payments ppp

1655: FROM pay_org_payment_methods_f pop,
1656: pay_assignment_actions paa,
1657: pay_payment_types ppt,
1658: pay_payment_types_tl ppttl,
1659: pay_pre_payments ppp
1660: WHERE paa.assignment_action_id = p_prepay_assact_id
1661: AND ppt.payment_type_id = pop.payment_type_id
1662: AND ppt.payment_type_id = ppttl.payment_type_id
1663: AND ppttl.language = userenv('LANG')

Line 1686: pay_pre_payments ppp

1682: pay_personal_payment_methods_f ppm,
1683: pay_assignment_actions paa,
1684: pay_payment_types ppt,
1685: pay_payment_types_tl ppttl,
1686: pay_pre_payments ppp
1687: WHERE
1688: -- pea.id_flex_num=20 AND
1689: pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1690: AND paa.assignment_action_id = p_prepay_assact_id