APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_PRE_PAYMENTS

Line 1237: FROM pay_pre_payments

1233: /* Cursor to fetch ppm and opm ids to check which payment method to archive */
1234: CURSOR csr_chk(p_prepay_assact_id NUMBER) IS
1235: SELECT personal_payment_method_id ppm_id,
1236: org_payment_method_id opm_id
1237: FROM pay_pre_payments
1238: WHERE assignment_action_id = p_prepay_assact_id;
1239: /* Cursor to check if bank details are attached with ppm */
1240: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1241: SELECT ppm.external_account_id

Line 1256: pay_pre_payments ppp

1252: FROM pay_org_payment_methods_f pop,
1253: pay_assignment_actions paa,
1254: pay_payment_types ppt,
1255: pay_payment_types_tl ppttl,
1256: pay_pre_payments ppp
1257: WHERE paa.assignment_action_id = p_prepay_assact_id
1258: AND ppt.payment_type_id = pop.payment_type_id
1259: AND ppt.payment_type_id = ppttl.payment_type_id
1260: AND ppttl.language = userenv('LANG')

Line 1283: pay_pre_payments ppp

1279: pay_personal_payment_methods_f ppm,
1280: pay_assignment_actions paa,
1281: pay_payment_types ppt,
1282: pay_payment_types_tl ppttl,
1283: pay_pre_payments ppp
1284: WHERE pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1285: AND paa.assignment_action_id = p_prepay_assact_id
1286: AND paa.assignment_id = ppm.assignment_id
1287: AND ppm.org_payment_method_id = pop.org_payment_method_id