APPS.GMS_AP_API2 dependencies on AP_INVOICES_ALL

Line 142: l_invoice_num ap_invoices_all.invoice_num%TYPE ;

138: l_award_idX NUMBER ;
139: l_status NUMBER ;
140: AWARD_NOT_FOUND EXCEPTION ;
141:
142: l_invoice_num ap_invoices_all.invoice_num%TYPE ;
143:
144: cursor c_ap is
145: SELECT A.invoice_id INVOICE_ID,
146: A.distribution_line_number distribution_line_number,

Line 160: ap_invoices_all inv

156: inv.invoice_num invoice_num
157: from ap_invoice_distributions_all A,
158: pa_projects_all p,
159: gms_project_types gpt,
160: ap_invoices_all inv
161: where a.invoice_id = p_invoice_id
162: and a.project_id = p.project_id
163: and p.project_type = gpt.project_type
164: and inv.invoice_id = a.invoice_id