eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_AP_API2 dependencies on PA_PROJECTS_ALL

Line 158: pa_projects_all p,

154: A.created_by CREATED_BY,
155: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
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

Line 180: PA_PROJECTS_ALL P,

176: A.created_by CREATED_BY,
177: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
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

Line 198: pa_projects_all p,

194:
195: cursor c2 is
196: SELECT 1
197: from ap_invoice_distributions_all A,
198: pa_projects_all p,
199: gms_project_types gpt
200: where a.invoice_id = p_invoice_id
201: and a.project_id = p.project_id
202: and p.project_type = gpt.project_type

Line 214: PA_PROJECTS_ALL P,

210: and adl.adl_status = 'A' )
211: union /* BUG 14216205 : Added the union for SAT */
212: select 1
213: FROM AP_SELF_ASSESSED_TAX_DIST_ALL b,
214: PA_PROJECTS_ALL P,
215: GMS_PROJECT_TYPES_ALL GPT
216: WHERE b.invoice_id = p_invoice_id
217: AND b.project_id = p.project_id
218: AND P.PROJECT_TYPE = GPT.PROJECT_TYPE

Line 332: pa_projects_all p,

328: cursor C6(p_invoice_id in number)
329: IS
330: select a.invoice_distribution_id
331: from ap_invoice_distributions_all A,
332: pa_projects_all p,
333: gms_project_types gpt
334: where a.invoice_id = p_invoice_id
335: and a.project_id = p.project_id
336: and a.award_id is not NULL

Line 342: pa_projects_all p,

338: and gpt.sponsored_flag = 'N'
339: union
340: select b.INVOICE_DISTRIBUTION_ID
341: from AP_SELF_ASSESSED_TAX_DIST_ALL B,
342: pa_projects_all p,
343: gms_project_types gpt
344: where b.invoice_id = p_invoice_id
345: and b.project_id = p.project_id
346: and b.award_id is not NULL

Line 541: pa_projects_all p,

537: /* BUG 14216205 : Commented the below code : Starts */
538: /*select a.invoice_distribution_id
539: bulk collect into l_dummy_tab
540: from ap_invoice_distributions_all A,
541: pa_projects_all p,
542: gms_project_types gpt
543: where a.invoice_id = p_invoice_id
544: and a.project_id = p.project_id
545: and a.award_id is not NULL