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_OIE_INT_PKG dependencies on PA_PROJECTS_ALL

Line 107: from pa_projects_all b,

103: BEGIN
104:
105: select nvl(pt.sponsored_flag, 'N')
106: into p_sponsored_flag
107: from pa_projects_all b,
108: gms_project_types pt
109: where b.segment1 = p_project_num
110: and b.project_type = pt.project_type
111: and pt.sponsored_flag = 'Y';

Line 335: pa_projects_all pp

331: from ap_invoice_distributions_all aid,
332: ap_expense_report_headers_all aerh,
333: ap_expense_report_lines_all aerl,
334: gms_project_types gpt,
335: pa_projects_all pp
336: where aerh.vouchno = aid.invoice_id
337: and aerh.report_header_id = aerl.report_header_id
338: and aid.invoice_id = v_invoice_id
339: and aid.distribution_line_number = aerl.distribution_line_number

Line 369: pa_projects_all pp, gms_project_types gpt

365: select aeh.report_header_id, aerl.project_id bulk collect
366: into cur_report_header_id, cur_project_id
367: from ap_expense_report_headers_all aeh,
368: ap_expense_report_lines_all aerl,
369: pa_projects_all pp, gms_project_types gpt
370: where aeh.report_header_id = aerl.report_header_id
371: and aeh.vouchno = p_invoice_id(i)
372: and aerl.project_id = pp.project_id
373: and pp.project_type = gpt.project_type