DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 880: FROM AP_PREPAY_HISTORY_ALL APPH, AP_INVOICE_DISTRIBUTIONS AID

876:
877: CURSOR prepay_adj_events(l_prepay_app_event_id NUMBER,
878: l_accounting_date DATE) is
879: SELECT APPH.accounting_event_id
880: FROM AP_PREPAY_HISTORY_ALL APPH, AP_INVOICE_DISTRIBUTIONS AID
881: WHERE APPH.related_prepay_app_Event_id = l_prepay_app_event_id
882: AND APPH.invoice_adjustment_event_id = AID.accounting_event_id
883: AND nvl(APPH.posted_flag,'N') = 'N'
884: AND AID.accounting_date = l_accounting_date;

Line 7242: INSERT INTO AP_PREPAY_HISTORY_ALL

7238: ELSE
7239: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
7240: END IF;
7241:
7242: INSERT INTO AP_PREPAY_HISTORY_ALL
7243: ( PREPAY_HISTORY_ID
7244: ,PREPAY_INVOICE_ID
7245: ,PREPAY_LINE_NUM
7246: ,ACCOUNTING_EVENT_ID

Line 7333: INSERT INTO AP_PREPAY_HISTORY_ALL

7329: ELSE
7330: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
7331: END IF;
7332:
7333: INSERT INTO AP_PREPAY_HISTORY_ALL
7334: ( PREPAY_HISTORY_ID
7335: ,PREPAY_INVOICE_ID
7336: ,PREPAY_LINE_NUM
7337: ,ACCOUNTING_EVENT_ID