APPS.PY_ROLLBACK_PKG dependencies on PAY_PRE_PAYMENTS

Line 147: from pay_pre_payments

143: is
144: cursor get_payment(p_pact in number)
145: is
146: select pre_payment_id
147: from pay_pre_payments
148: where payroll_action_id = p_pact;
149: begin
150: --
151: for payrec in get_payment(p_pactid) loop

Line 156: delete from pay_pre_payments

152: --
153: update pay_contributing_payments
154: set pre_payment_id = null
155: where pre_payment_id = payrec.pre_payment_id;
156: delete from pay_pre_payments
157: where pre_payment_id = payrec.pre_payment_id;
158: --
159: end loop;
160: --

Line 510: pay_pre_payments ppp,

506: from pay_external_accounts pea,
507: pay_payment_types ppt,
508: pay_personal_payment_methods_f ppm,
509: pay_org_payment_methods_f opm,
510: pay_pre_payments ppp,
511: pay_payroll_actions ppa,
512: pay_assignment_actions paa
513: where paa.assignment_action_id = asgact
514: and paa.payroll_action_id = ppa.payroll_action_id

Line 1817: delete from pay_pre_payments ppp

1813: -- Note, this causes cascade delete of pay_coin_anal_elements.
1814: if g_debug then
1815: hr_utility.set_location('Error abt to occur', 13);
1816: end if;
1817: delete from pay_pre_payments ppp
1818: where ppp.assignment_action_id = p_info.assact_id;
1819: --
1820: elsif(p_info.action_type in ('C', 'S', 'EC')) then
1821: -- Remove costing rows.