DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on AP_AE_LINES_ALL

Line 3435: FROM ap_ae_lines_all l,

3431: BEGIN
3432: l_event_type_code := NULL;
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

Line 3520: FROM ap_ae_lines_all l,

3516: BEGIN
3517: l_event_type_code := NULL;
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