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_PAXMGURA_XMLP_PKG dependencies on PA_PROJECT_TYPES_ALL

Line 60: from pa_projects_all p, pa_project_types_all pt

56: IF proj is null THEN
57: IF from_project_number is null then
58: begin
59: select min(p.segment1) into from_project_number
60: from pa_projects_all p, pa_project_types_all pt
61: where p.project_type = pt.project_type
62: and pt.project_type_class_code = 'CONTRACT';
63: exception
64: when no_data_found then

Line 76: from pa_projects_all p, pa_project_types_all pt

72:
73: IF to_project_number is null then
74: begin
75: select max(p.segment1) into to_project_number
76: from pa_projects_all p, pa_project_types_all pt
77: where p.project_type = pt.project_type
78: and pt.project_type_class_code = 'CONTRACT';
79: exception
80: when no_data_found then