DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on AP_AE_LINES_ALL

Line 3643: FROM ap_ae_lines_all l,

3639: BEGIN
3640: l_event_type_code := NULL;
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

Line 3728: FROM ap_ae_lines_all l,

3724: BEGIN
3725: l_event_type_code := NULL;
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