APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 1025: FROM AP_PREPAY_HISTORY_ALL APPH, AP_INVOICE_DISTRIBUTIONS AID

1021:
1022: CURSOR prepay_adj_events(l_prepay_app_event_id NUMBER,
1023: l_accounting_date DATE) is
1024: SELECT APPH.accounting_event_id
1025: FROM AP_PREPAY_HISTORY_ALL APPH, AP_INVOICE_DISTRIBUTIONS AID
1026: WHERE APPH.related_prepay_app_Event_id = l_prepay_app_event_id
1027: AND APPH.invoice_adjustment_event_id = AID.accounting_event_id
1028: AND nvl(APPH.posted_flag,'N') = 'N';
1029: --AND AID.accounting_date = l_accounting_date; Commented for bug 10132577

Line 5067: FROM ap_prepay_history_all APPH

5063: AND AID.parent_reversal_id IS NULL
5064: AND NVL(AID.Historical_Flag, 'N') <> 'Y'
5065: AND NOT EXISTS
5066: (SELECT 1
5067: FROM ap_prepay_history_all APPH
5068: WHERE APPH.invoice_id = AID.invoice_id
5069: AND APPH.Invoice_Adjustment_Event_Id = P_Adj_Accounting_Event_Id
5070: AND APPH.Related_Prepay_App_Event_Id = AID.Accounting_Event_Id
5071: AND APPH.transaction_type = 'PREPAYMENT APPLICATION ADJ'

Line 5321: ap_prepay_history_all apph

5317: AND aid.accounting_event_id = p_adj_accounting_event_id
5318: AND NOT EXISTS
5319: (SELECT 1
5320: FROM ap_prepay_app_dists apad,
5321: ap_prepay_history_all apph
5322: WHERE apad.prepay_history_id = apph.prepay_history_id
5323: AND apph.transaction_type = 'PREPAYMENT APPLIED'
5324: AND apph.invoice_id = l_prepay_app_invoice_ids(i)
5325: AND apph.invoice_line_number = l_prepay_app_invoice_line_num(i)

Line 7793: l_related_prepay_app_event_id AP_PREPAY_HISTORY_ALL.related_prepay_app_event_id%TYPE;

7789:
7790: l_curr_calling_sequence VARCHAR2(2000);
7791: TYPE l_prepay_hist_list IS TABLE OF ap_prepay_history.prepay_history_id%TYPE;
7792: l_prepay_hist_tab l_prepay_hist_list;
7793: l_related_prepay_app_event_id AP_PREPAY_HISTORY_ALL.related_prepay_app_event_id%TYPE;
7794:
7795: -- Logging:
7796: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_Prepayment_Header';
7797: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 8009: INSERT INTO AP_PREPAY_HISTORY_ALL

8005: ELSE
8006: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
8007: END IF;
8008:
8009: INSERT INTO AP_PREPAY_HISTORY_ALL
8010: ( PREPAY_HISTORY_ID
8011: ,PREPAY_INVOICE_ID
8012: ,PREPAY_LINE_NUM
8013: ,ACCOUNTING_EVENT_ID

Line 8101: INSERT INTO AP_PREPAY_HISTORY_ALL

8097: ELSE
8098: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
8099: END IF;
8100:
8101: INSERT INTO AP_PREPAY_HISTORY_ALL
8102: ( PREPAY_HISTORY_ID
8103: ,PREPAY_INVOICE_ID
8104: ,PREPAY_LINE_NUM
8105: ,ACCOUNTING_EVENT_ID