DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on AP_AE_HEADERS_ALL

Line 3436: ap_ae_headers_all h,

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
3440: AND l.ae_header_id = h.ae_header_id

Line 3521: ap_ae_headers_all h,

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
3525: AND l.ae_header_id = h.ae_header_id