APPS.PAY_CE_RECONCILIATION_PKG dependencies on PAY_CE_RECONCILED_PAYMENTS

Line 205: insert into pay_ce_reconciled_payments(

201: begin
202:
203: hr_utility.set_location('pay_ce_reconciliation_pkg.update_reconciled_payment', 10);
204:
205: insert into pay_ce_reconciled_payments(
206: reconciled_payment_id,
207: assignment_action_id,
208: trx_type,
209: cleared_amount,

Line 214: pay_ce_reconciled_payments_s.nextval,

210: cleared_date,
211: status_code,
212: cleared_base_amount)
213: values(
214: pay_ce_reconciled_payments_s.nextval,
215: p_payment_id,
216: p_trx_type,
217: p_trx_amount,
218: p_cleared_date,

Line 239: pay_ce_reconciled_payments

235: cursor c_reconciled_payment is
236: select
237: reconciled_payment_id
238: from
239: pay_ce_reconciled_payments
240: where
241: assignment_action_id = p_payment_id;
242:
243: begin

Line 251: delete from pay_ce_reconciled_payments

247: open c_reconciled_payment;
248: fetch c_reconciled_payment into l_reconciled_payment_id;
249: if c_reconciled_payment%found then
250:
251: delete from pay_ce_reconciled_payments
252: where reconciled_payment_id = l_reconciled_payment_id;
253:
254: else
255:

Line 283: pay_ce_reconciled_payments

279: cursor c_payment is
280: select
281: null
282: from
283: pay_ce_reconciled_payments
284: where
285: assignment_action_id = p_payment_id
286: and status_code = 'C';
287: