APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 555: ,ap_prepay_history_all apph

551: ,ai.legal_entity_id
552: ,G_SRC_TYP_UNACCT_PREPAY_HIST
553: ,G_SRC_TAB_AP_PREPAY_HIST
554: from ap_invoices_all ai
555: ,ap_prepay_history_all apph
556: ,ap_org_attributes_gt org_gtt
557: where
558: ai.invoice_id = apph.invoice_id
559: and ( apph.accounting_date between g_period_start_date and g_period_end_date)

Line 951: ,ap_prepay_history_all apph

947: ,xla_events_unacct(i).entity_code
948: ,G_SRC_TYP_OTHER_EXCPS
949: ,G_SRC_TAB_AP_PREPAY_HIST
950: FROM ap_invoices_all ai
951: ,ap_prepay_history_all apph
952: ,ap_org_attributes_gt org_gtt
953: WHERE apph.invoice_id = ai.invoice_id(+)
954: AND apph.accounting_event_id IS NOT NULL
955: AND ai.set_of_books_id = g_ledger_id

Line 2231: UPDATE ap_prepay_history_all apph

2227: Itab_event_id.delete; --Bug 9045217
2228:
2229: -- gagrawal
2230:
2231: UPDATE ap_prepay_history_all apph
2232: SET accounting_date = g_sweep_to_date,
2233: last_update_date = sysdate,
2234: last_updated_by = 5
2235: WHERE apph.accounting_event_id in (SELECT gt.accounting_event_id

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

2239: AND gt.accounting_event_id IS NOT NULL)
2240: AND apph.posted_flag <> 'Y'
2241: returning apph.accounting_event_id bulk collect into ltab_id;
2242:
2243: debug ('update_ap_acct_date: total records updated in ap_prepay_history_all: '||sql%rowcount);
2244:
2245:
2246: forall i in ltab_id.first .. ltab_id.last
2247: update ap_period_close_excps_gt gt