DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 781: FROM ap_invoice_payments_all aip,

777: ac.party_id,
778: ac.vendor_id
779: ,G_SRC_TYP_UNACCT_INV_PMTS
780: ,G_SRC_TAB_AP_INV_PAYMENTS
781: FROM ap_invoice_payments_all aip,
782: ap_checks_All ac,
783: ap_org_attributes_gt orgs
784: WHERE aip.posted_flag IN ('N','S')
785: -- bug 7311486 UTR report must run even if dates and period is not specified

Line 860: FROM ap_invoice_payments_all aip

856: FROM ap_prepay_history_all apph
857: WHERE apph.bc_event_id = xe.event_id)
858: AND NOT EXISTS
859: (SELECT 1
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

Line 1383: from ap_invoice_payments_all aip,

1379: if (nvl(p_inv_payment_id ,-1) > 0) then -- 7318763
1380: BEGIN
1381: select ac.check_id, ac.check_number
1382: into l_check_id, l_check_number
1383: from ap_invoice_payments_all aip,
1384: ap_checks_all ac
1385: where aip.check_id=ac.check_id
1386: and aip.accounting_event_id = p_event_id
1387: and aip.invoice_id= p_trans_id;

Line 1894: UPDATE ap_invoice_payments_all aip

1890: debug ('update_ap_acct_date: total invoice lines processed in ap_period_close_excps_gt: '||ltab_id.count );
1891:
1892: ltab_id.delete;
1893:
1894: UPDATE ap_invoice_payments_all aip
1895: SET accounting_date = g_sweep_to_date,
1896: period_name = g_sweep_to_period,
1897: last_update_date = sysdate,
1898: last_updated_by = 5

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

1902: AND gt.source_table_name = G_SRC_TAB_AP_INV_PAYMENTS)
1903: AND aip.posted_flag <> 'Y'
1904: returning invoice_payment_id bulk collect into ltab_id;
1905:
1906: debug ('update_ap_acct_date: total records updated in ap_invoice_payments_all: '||sql%rowcount);
1907:
1908: forall i in ltab_id.first .. ltab_id.last
1909: update ap_period_close_excps_gt gt
1910: set process_status_flag = 'Y'

Line 2056: FROM ap_invoice_payments_all aip

2052: FROM ap_prepay_history_all apph
2053: WHERE apph.bc_event_id = xe.event_id)
2054: AND NOT EXISTS
2055: (SELECT 1
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