DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on AP_ACCOUNTING_EVENTS

Line 3345: l_event_type_code ap_accounting_events.event_type_code%TYPE;

3341: l_inv_payment_id Number;
3342: l_gl_date Date;
3343: l_rec_public_law_code VARCHAR2(150);
3344: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
3345: l_event_type_code ap_accounting_events.event_type_code%TYPE;
3346: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
3347: l_dummy_rev_exists VARCHAR2(1);
3348:
3349:

Line 3770: ap_accounting_events_all e

3766: SELECT e.event_type_code
3767: INTO l_event_type_code
3768: FROM ap_ae_lines_all l,
3769: ap_ae_headers_all h,
3770: ap_accounting_events_all e
3771: WHERE l.source_table = 'AP_INVOICES'
3772: AND l.source_id = p_reference2
3773: AND l.ae_header_id = h.ae_header_id
3774: AND l.gl_sl_link_id = p_gl_sl_link_id

Line 3847: ap_accounting_events_all e

3843: SELECT e.event_type_code
3844: INTO l_event_type_code
3845: FROM ap_ae_lines_all l,
3846: ap_ae_headers_all h,
3847: ap_accounting_events_all e
3848: WHERE l.source_table = 'AP_INVOICE_PAYMENTS'
3849: AND l.source_id = p_reference9
3850: AND l.ae_header_id = h.ae_header_id
3851: AND l.gl_sl_link_id = p_gl_sl_link_id