APPS.GMS_AP_API dependencies on AP_INVOICES_ALL

Line 745: l_invoice_num ap_invoices_all.invoice_num%TYPE ;

741: l_award_idX NUMBER ;
742: l_status NUMBER ;
743: AWARD_NOT_FOUND EXCEPTION ;
744:
745: l_invoice_num ap_invoices_all.invoice_num%TYPE ;
746:
747: cursor c_ap is
748: SELECT A.invoice_id INVOICE_ID,
749: A.distribution_line_number distribution_line_number,

Line 763: ap_invoices_all inv

759: inv.invoice_num invoice_num
760: from ap_invoice_distributions_all A,
761: pa_projects_all p,
762: gms_project_types gpt,
763: ap_invoices_all inv
764: where a.invoice_id = p_invoice_id
765: and a.project_id = p.project_id
766: and p.project_type = gpt.project_type
767: and inv.invoice_id = a.invoice_id