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.PA_PAXINGEN_XMLP_PKG dependencies on PA_PROJECTS

Line 213: from pa_projects

209: IF project_id is not null then
210: begin
211: select segment1,name
212: into p_number,p_name
213: from pa_projects
214: where project_id = PA_PAXINGEN_XMLP_PKG.project_id;
215: exception
216: when no_data_found then
217: null;

Line 274: from pa_projects_all p, pa_project_types_all pt

270: IF project_id is null Then
271: IF from_project_number is null then
272: begin
273: select min(p.segment1) into from_project_number
274: from pa_projects_all p, pa_project_types_all pt
275: where p.project_type = pt.project_type
276: and pt.project_type_class_code = 'CONTRACT';
277: exception
278: when no_data_found then

Line 289: from pa_projects_all p, pa_project_types_all pt

285:
286: IF to_project_number is null then
287: begin
288: select max(p.segment1) into to_project_number
289: from pa_projects_all p, pa_project_types_all pt
290: where p.project_type = pt.project_type
291: and pt.project_type_class_code = 'CONTRACT';
292: exception
293: when no_data_found then