APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 265: from ap_payment_history_all aph

261: )
262: and ai.approval_ready_flag <> 'S' --bug 9224843
263: and not exists
264: (select 1
265: from ap_payment_history_all aph
266: where aph.accounting_event_id = aid.accounting_event_id
267: and ai.invoice_type_lookup_code = 'INTEREST'
268: and nvl(org_gtt.when_to_account_pmt, 'ALWAYS') = 'CLEARING ONLY'
269: and aph.transaction_type not in ('PAYMENT CLEARING', 'PAYMENT UNCLEARING'))

Line 311: from ap_payment_history_all aph

307: )
308: and ai.approval_ready_flag <> 'S'
309: and not exists
310: (select 1
311: from ap_payment_history_all aph
312: where aph.accounting_event_id = aid.accounting_event_id
313: and ai.invoice_type_lookup_code = 'INTEREST'
314: and nvl(org_gtt.when_to_account_pmt, 'ALWAYS') = 'CLEARING ONLY'
315: and aph.transaction_type not in ('PAYMENT CLEARING', 'PAYMENT UNCLEARING'))

Line 633: FROM ap_payment_history_all aph,

629: ac.party_id,
630: ac.vendor_id
631: ,G_SRC_TYP_UNACCT_PMT_HISTORY
632: ,G_SRC_TAB_AP_PMT_HISTORY
633: FROM ap_payment_history_all aph,
634: ap_checks_all ac,
635: ap_org_attributes_gt orgs
636: WHERE aph.posted_flag IN ('N','S')
637: AND ac.check_id = aph.check_id

Line 1013: FROM ap_payment_history_all aph,

1009: ,xla_events_unacct(i).event_type_code
1010: ,xla_events_unacct(i).entity_code
1011: ,G_SRC_TYP_OTHER_EXCPS
1012: ,G_SRC_TAB_AP_PMT_HISTORY
1013: FROM ap_payment_history_all aph,
1014: ap_checks_all ac,
1015: ap_org_attributes_gt orgs
1016: WHERE aph.check_id = ac.check_id(+)
1017: AND aph.org_id = orgs.org_id

Line 1914: FROM AP_Payment_History_ALL APH

1910: G_SRC_TAB_AP_SELF_TAX_DIST_ALL, G_SRC_TAB_AP_PREPAY_HIST)
1911: AND gt.accounting_event_id is NOT NULL
1912: AND NOT EXISTS
1913: (SELECT 'check if invoice dist has payment event'
1914: FROM AP_Payment_History_ALL APH
1915: WHERE APH.Accounting_Event_ID = GT.Accounting_Event_ID
1916: AND GT.Accounting_Event_ID IS NOT NULL
1917: AND GT.Source_Type = G_SRC_TYP_UNACCT_DISTS);
1918:

Line 2204: UPDATE ap_payment_history_all aph

2200:
2201: ltab_id.delete;
2202: Itab_event_id.delete; --Bug 9045217
2203:
2204: UPDATE ap_payment_history_all aph
2205: SET accounting_date = g_sweep_to_date,
2206: last_update_date = sysdate,
2207: last_updated_by = 5
2208: WHERE aph.payment_history_id in (SELECT gt.payment_history_id

Line 2215: debug ('update_ap_acct_date: total records updated in ap_payment_history_all: '||sql%rowcount);

2211: AND gt.source_table_name = G_SRC_TAB_AP_PMT_HISTORY)
2212: AND aph.posted_flag <> 'Y'
2213: returning aph.payment_history_id,aph.accounting_event_id bulk collect into ltab_id,Itab_event_id; --Bug 9045217
2214:
2215: debug ('update_ap_acct_date: total records updated in ap_payment_history_all: '||sql%rowcount);
2216:
2217: forall i in ltab_id.first .. ltab_id.last
2218: update ap_period_close_excps_gt gt
2219: set process_status_flag = 'Y'