APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 709: FROM ap_payment_history_all aph,

705: ac.party_id,
706: ac.vendor_id
707: ,G_SRC_TYP_UNACCT_PMT_HISTORY
708: ,G_SRC_TAB_AP_PMT_HISTORY
709: FROM ap_payment_history_all aph,
710: ap_checks_all ac,
711: ap_org_attributes_gt orgs
712: WHERE aph.posted_flag IN ('N','S')
713: AND ac.check_id = aph.check_id

Line 864: FROM ap_payment_history_all aph

860: FROM ap_invoice_payments_all aip
861: WHERE aip.accounting_event_id = xe.event_id)
862: AND NOT EXISTS
863: (SELECT 1
864: FROM ap_payment_history_all aph
865: WHERE aph.accounting_event_id = xe.event_id)
866: AND event_type_code <> 'MANUAL');
867:
868: EXCEPTION

Line 1920: UPDATE ap_payment_history_all aph

1916:
1917: ltab_id.delete;
1918:
1919:
1920: UPDATE ap_payment_history_all aph
1921: SET accounting_date = g_sweep_to_date,
1922: last_update_date = sysdate,
1923: last_updated_by = 5
1924: WHERE aph.payment_history_id in (SELECT gt.payment_history_id

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

1927: AND gt.source_table_name = G_SRC_TAB_AP_PMT_HISTORY)
1928: AND aph.posted_flag <> 'Y'
1929: returning aph.payment_history_id bulk collect into ltab_id;
1930:
1931: debug ('update_ap_acct_date: total records updated in ap_payment_history_all: '||sql%rowcount);
1932:
1933: forall i in ltab_id.first .. ltab_id.last
1934: update ap_period_close_excps_gt gt
1935: set process_status_flag = 'Y'

Line 2060: FROM ap_payment_history_all aph

2056: FROM ap_invoice_payments_all aip
2057: WHERE aip.accounting_event_id = xe.event_id)
2058: AND NOT EXISTS
2059: (SELECT 1
2060: FROM ap_payment_history_all aph
2061: WHERE aph.accounting_event_id = xe.event_id)
2062: AND xe.event_type_code <> 'MANUAL';
2063:
2064: BEGIN