APPS.AP_DRILLDOWN_PUB_PKG dependencies on AP_INVOICES

Line 385: FROM gl_ledgers gl, ap_invoices_all ai

381:
382: --bug9444952
383: SELECT nvl(gl.sla_ledger_cash_basis_flag, 'N')
384: INTO l_cash_basis_flag
385: FROM gl_ledgers gl, ap_invoices_all ai
386: WHERE gl.ledger_id = ai.set_of_books_id
387: AND ai.invoice_id = p_invoice_id;
388:
389: -- bug9444952 : Setting posted flags to appropriate statuses

Line 739: from ap_invoices

735: ----------------------------------------------------------------
736:
737: select invoice_num
738: into l_invoice_num
739: from ap_invoices
740: where invoice_id = p_invoice_id;
741:
742: ----------------------------------------------------------------
743: l_log_msg :='get event source information';

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

745:
746: l_event_source_info.application_id := 200;
747: l_event_source_info.legal_entity_id := p_legal_entity_id;
748: l_event_source_info.ledger_id := p_ledger_id;
749: l_event_source_info.entity_type_code := 'AP_INVOICES';
750: l_event_source_info.transaction_number := l_invoice_num;
751: l_event_source_info.source_id_int_1 := p_invoice_id;
752:
753: RETURN l_event_source_info;

Line 899: ap_invoices AI

895: p_org_id,
896: p_legal_entity_id,
897: p_ledger_id
898: FROM
899: ap_invoices AI
900: WHERE
901: AI.invoice_id = p_invoice_id;
902:
903: EXCEPTION