APPS.AP_ACCTG_DATA_FIX_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 2346: UPDATE ap_Payment_History_All aph

2342: l_event_status_code = 'U') THEN
2343:
2344: BEGIN
2345:
2346: UPDATE ap_Payment_History_All aph
2347: SET Accounting_Date = l_gl_Date,
2348: Posted_Flag = 'N',
2349: Last_Updated_By = fnd_Global.User_Id
2350: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id

Line 2388: FROM ap_Payment_History_All

2384: DELETE
2385: FROM ap_Payment_Hist_dIsts
2386: WHERE Payment_History_Id IN
2387: (SELECT Payment_History_Id
2388: FROM ap_Payment_History_All
2389: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2390: AND Check_Id = l_Source_Id);
2391:
2392: p_return_code := 'SUCCESS';

Line 3379: ap_payment_history_all aph,

3375: asp.rounding_error_ccid),
3376: asp.rounding_error_ccid
3377: ) write_off_code_combination
3378: FROM ap_payment_hist_dists aphd,
3379: ap_payment_history_all aph,
3380: ap_system_parameters_all asp,
3381: ap_invoice_distributions_all aid
3382: WHERE aphd.accounting_event_id = p_event_id
3383: AND aph.payment_history_id = aphd.payment_history_id

Line 3724: FROM ap_payment_history_all aph,

3720: WHERE xe.application_id = 200
3721: AND xe.event_status_code = 'P'
3722: AND xe.event_id IN
3723: (SELECT aph.accounting_event_id
3724: FROM ap_payment_history_all aph,
3725: ap_invoice_payments_all aip
3726: WHERE aip.check_id = aph.check_id
3727: AND aip.invoice_id = l_invoice_id
3728: AND aph.rev_pmt_hist_id IS NULL

Line 3738: FROM ap_payment_history_all aph_rev

3734: 'PAYMENT CLEARING ADJUSTED'
3735: )
3736: AND NOT EXISTS
3737: (SELECT 1
3738: FROM ap_payment_history_all aph_rev
3739: WHERE aph_rev.check_id = aph.check_id
3740: AND nvl(aph_rev.related_event_id, aph_rev.accounting_event_id)
3741: = nvl(aph.related_event_id, aph.accounting_event_id)
3742: AND aph_rev.rev_pmt_hist_id IS NOT NULL

Line 4215: FROM ap_payment_history_all aph

4211: l_orgid NUMBER(10);
4212:
4213: CURSOR payment_cascade_adj_cur IS
4214: SELECT DISTINCT aph_adj.accounting_event_id
4215: FROM ap_payment_history_all aph
4216: , xla_events xe
4217: , ap_payment_history_all aph_adj
4218: , xla_events xe_adj
4219: WHERE aph.check_id = p_source_id

Line 4217: , ap_payment_history_all aph_adj

4213: CURSOR payment_cascade_adj_cur IS
4214: SELECT DISTINCT aph_adj.accounting_event_id
4215: FROM ap_payment_history_all aph
4216: , xla_events xe
4217: , ap_payment_history_all aph_adj
4218: , xla_events xe_adj
4219: WHERE aph.check_id = p_source_id
4220: AND aph.accounting_event_id = NVL(p_related_event_id
4221: , aph.accounting_event_id)

Line 4394: DELETE ap_payment_history_all aph

4390: WHERE xe.event_id = aphd.accounting_event_id
4391: AND xe.application_id = 200
4392: );
4393:
4394: DELETE ap_payment_history_all aph
4395: WHERE aph.accounting_event_id = i.accounting_event_id
4396: AND NOT EXISTS
4397: (
4398: SELECT 1