APPS.PY_ROLLBACK_PKG dependencies on PAY_PRE_PAYMENTS

Line 142: from pay_pre_payments

138: is
139: cursor get_payment(p_pact in number)
140: is
141: select pre_payment_id
142: from pay_pre_payments
143: where payroll_action_id = p_pact;
144: begin
145: --
146: for payrec in get_payment(p_pactid) loop

Line 151: delete from pay_pre_payments

147: --
148: update pay_contributing_payments
149: set pre_payment_id = null
150: where pre_payment_id = payrec.pre_payment_id;
151: delete from pay_pre_payments
152: where pre_payment_id = payrec.pre_payment_id;
153: --
154: end loop;
155: --

Line 505: pay_pre_payments ppp,

501: from pay_external_accounts pea,
502: pay_payment_types ppt,
503: pay_personal_payment_methods_f ppm,
504: pay_org_payment_methods_f opm,
505: pay_pre_payments ppp,
506: pay_payroll_actions ppa,
507: pay_assignment_actions paa
508: where paa.assignment_action_id = asgact
509: and paa.payroll_action_id = ppa.payroll_action_id

Line 1794: delete from pay_pre_payments ppp

1790: -- Note, this causes cascade delete of pay_coin_anal_elements.
1791: if g_debug then
1792: hr_utility.set_location('Error abt to occur', 13);
1793: end if;
1794: delete from pay_pre_payments ppp
1795: where ppp.assignment_action_id = p_info.assact_id;
1796: --
1797: elsif(p_info.action_type in ('C', 'S', 'EC')) then
1798: -- Remove costing rows.