APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 703: FROM ap_invoice_payments_all aip,

699: ac.party_id,
700: ac.vendor_id
701: ,G_SRC_TYP_UNACCT_INV_PMTS
702: ,G_SRC_TAB_AP_INV_PAYMENTS
703: FROM ap_invoice_payments_all aip,
704: ap_checks_All ac,
705: ap_org_attributes_gt orgs
706: WHERE aip.posted_flag IN ('N','S')
707: and (aip.accounting_date between g_period_start_date and g_period_end_date)

Line 1646: from ap_invoice_payments_all aip,

1642:
1643: select DISTINCT ac.check_id, --bug9649978
1644: ac.check_number
1645: into l_check_id, l_check_number
1646: from ap_invoice_payments_all aip,
1647: ap_checks_all ac
1648: where aip.check_id=ac.check_id
1649: and aip.accounting_event_id = p_event_id
1650: and aip.invoice_id= p_trans_id;

Line 2177: UPDATE ap_invoice_payments_all aip

2173: debug ('update_ap_acct_date: total invoice lines processed in ap_period_close_excps_gt: '||ltab_id.count );
2174:
2175: ltab_id.delete;
2176:
2177: UPDATE ap_invoice_payments_all aip
2178: SET accounting_date = g_sweep_to_date,
2179: period_name = g_sweep_to_period,
2180: last_update_date = sysdate,
2181: last_updated_by = 5

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

2185: AND gt.source_table_name = G_SRC_TAB_AP_INV_PAYMENTS)
2186: AND aip.posted_flag <> 'Y'
2187: returning invoice_payment_id, accounting_event_id bulk collect into ltab_id,Itab_event_id; --Bug 9045217
2188:
2189: debug ('update_ap_acct_date: total records updated in ap_invoice_payments_all: '||sql%rowcount);
2190:
2191: forall i in ltab_id.first .. ltab_id.last
2192: update ap_period_close_excps_gt gt
2193: set process_status_flag = 'Y'