[Home] [Help]
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
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