APPS.AP_DRILLDOWN_PUB_PKG dependencies on AP_INVOICES

Line 678: from ap_invoices

674: ----------------------------------------------------------------
675:
676: select invoice_num
677: into l_invoice_num
678: from ap_invoices
679: where invoice_id = p_invoice_id;
680:
681: ----------------------------------------------------------------
682: l_log_msg :='get event source information';

Line 688: l_event_source_info.entity_type_code := 'AP_INVOICES';

684:
685: l_event_source_info.application_id := 200;
686: l_event_source_info.legal_entity_id := p_legal_entity_id;
687: l_event_source_info.ledger_id := p_ledger_id;
688: l_event_source_info.entity_type_code := 'AP_INVOICES';
689: l_event_source_info.transaction_number := l_invoice_num;
690: l_event_source_info.source_id_int_1 := p_invoice_id;
691:
692: RETURN l_event_source_info;

Line 838: ap_invoices AI

834: p_org_id,
835: p_legal_entity_id,
836: p_ledger_id
837: FROM
838: ap_invoices AI
839: WHERE
840: AI.invoice_id = p_invoice_id;
841:
842: EXCEPTION