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

Line 182: AP_INVOICES_ALL INV

178: inv.invoice_num invoice_num
179: FROM ap_self_assessed_tax_dist_all A,
180: PA_PROJECTS_ALL P,
181: gms_project_types gpt,
182: AP_INVOICES_ALL INV
183: WHERE a.invoice_id = p_invoice_id
184: AND a.project_id = p.project_id
185: AND A.line_type_lookup_code='NONREC_TAX'
186: AND p.project_type = gpt.project_type