DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on AP_INVOICES_ALL

Line 491: from ap_invoices_all ap,

487: ap.vendor_id,
488: pet.expenditure_category,
489: pet.revenue_category_code,
490: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
491: from ap_invoices_all ap,
492: gms_award_distributions adl,
493: ap_invoice_distributions aid,
494: gl_period_statuses gps,
495: pa_expenditure_types pet,

Line 1459: FROM ap_invoices_all head,

1455: AND x_document_type = 'AP' THEN
1456: g_error_stage := 'VI-AP';
1457: SELECT DISTINCT head.vendor_id
1458: INTO x_vendor_id
1459: FROM ap_invoices_all head,
1460: gms_bc_packets bc
1461: WHERE bc.packet_id = x_packet_id
1462: AND bc.document_header_id = head.invoice_id
1463: AND bc.bc_packet_id = x_bc_packet_id;