DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on AP_ACCOUNTING_EVENTS

Line 3177: l_event_type_code ap_accounting_events.event_type_code%TYPE;

3173: l_inv_payment_id Number;
3174: l_gl_date Date;
3175: l_rec_public_law_code VARCHAR2(150);
3176: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
3177: l_event_type_code ap_accounting_events.event_type_code%TYPE;
3178: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
3179: l_dummy_rev_exists VARCHAR2(1);
3180:
3181:

Line 3645: ap_accounting_events_all e

3641: SELECT e.event_type_code
3642: INTO l_event_type_code
3643: FROM ap_ae_lines_all l,
3644: ap_ae_headers_all h,
3645: ap_accounting_events_all e
3646: WHERE l.source_table = 'AP_INVOICES'
3647: AND l.source_id = p_reference2
3648: AND l.ae_header_id = h.ae_header_id
3649: AND l.gl_sl_link_id = p_gl_sl_link_id

Line 3730: ap_accounting_events_all e

3726: SELECT e.event_type_code
3727: INTO l_event_type_code
3728: FROM ap_ae_lines_all l,
3729: ap_ae_headers_all h,
3730: ap_accounting_events_all e
3731: WHERE l.source_table = 'AP_INVOICE_PAYMENTS'
3732: AND l.source_id = p_reference9
3733: AND l.ae_header_id = h.ae_header_id
3734: AND l.gl_sl_link_id = p_gl_sl_link_id