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_PROJECT_UTILS2 dependencies on PA_PROJECT_TYPES

Line 83: , pa_project_types_all pt -- Bug#3807805 : Modified pa_project_types to pa_project_types_all

79: , 'CAPITAL',org_information12
80: , 'CONTRACT',org_information13),'Y')
81: ,meaning
82: from hr_organization_information org
83: , pa_project_types_all pt -- Bug#3807805 : Modified pa_project_types to pa_project_types_all
84: , pa_lookups lps
85: where org.organization_id(+) = nvl(x_new_value,x_old_value)
86: and upper(org.org_information_context(+)) = upper('Project Type Class Information')
87: and pt.project_type = x_project_type

Line 106: select org_id into PA_PROJECT_REQUEST_PVT.G_ORG_ID from pa_project_types where project_type = X_project_type;

102: -- PT class for a Project is determined from the project type specified
103: -- for the Project.
104: --
105: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and X_project_type is not null then -- Added the if block for Bug#3807805
106: select org_id into PA_PROJECT_REQUEST_PVT.G_ORG_ID from pa_project_types where project_type = X_project_type;
107: end if;
108:
109: open c;
110: fetch c into x_yes_no

Line 218: pa_project_types_all pt -- Bug#3807805 : Modified pa_project_types to pa_project_types_all

214: IF x_project_id IS NOT NULL THEN
215: select pt.project_type_class_code
216: into l_proj_type_class_code
217: from pa_projects_all p, -- Bug#3807805 : Modified pa_projects to pa_projects_all
218: pa_project_types_all pt -- Bug#3807805 : Modified pa_project_types to pa_project_types_all
219: where p.project_id = X_Project_ID
220: and p.project_type = pt.project_type
221: and p.org_id = pt.org_id; -- Added the and condition for Bug#3807805
222: END IF;