DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on AP_ACCOUNTING_EVENTS

Line 2963: l_event_type_code ap_accounting_events.event_type_code%TYPE;

2959: l_inv_payment_id Number;
2960: l_gl_date Date;
2961: l_rec_public_law_code VARCHAR2(150);
2962: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
2963: l_event_type_code ap_accounting_events.event_type_code%TYPE;
2964: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
2965: l_dummy_rev_exists VARCHAR2(1);
2966:
2967:

Line 3437: ap_accounting_events_all e

3433: SELECT e.event_type_code
3434: INTO l_event_type_code
3435: FROM ap_ae_lines_all l,
3436: ap_ae_headers_all h,
3437: ap_accounting_events_all e
3438: WHERE l.source_table = 'AP_INVOICES'
3439: AND l.source_id = p_reference2
3440: AND l.ae_header_id = h.ae_header_id
3441: AND l.gl_sl_link_id = p_gl_sl_link_id

Line 3522: ap_accounting_events_all e

3518: SELECT e.event_type_code
3519: INTO l_event_type_code
3520: FROM ap_ae_lines_all l,
3521: ap_ae_headers_all h,
3522: ap_accounting_events_all e
3523: WHERE l.source_table = 'AP_INVOICE_PAYMENTS'
3524: AND l.source_id = p_reference9
3525: AND l.ae_header_id = h.ae_header_id
3526: AND l.gl_sl_link_id = p_gl_sl_link_id