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 175: pa_projects_all p,

171:
172: cursor c2 is
173: SELECT 1
174: from ap_invoice_distributions_all A,
175: pa_projects_all p,
176: gms_project_types gpt
177: where a.invoice_id = p_invoice_id
178: and a.project_id = p.project_id
179: and p.project_type = gpt.project_type

Line 345: pa_projects_all p,

341: */
342: select a.invoice_distribution_id
343: bulk collect into l_dummy_tab
344: from ap_invoice_distributions_all A,
345: pa_projects_all p,
346: gms_project_types gpt
347: where a.invoice_id = p_invoice_id
348: and a.project_id = p.project_id
349: and a.award_id is not NULL