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.PJI_PMV_PREDICATE dependencies on PA_PROJECTS_ALL

Line 137: FROM pa_projects_all prj

133: IF p_Organization_ID IS NOT NULL THEN
134: IF NOT (UPPER(p_Org_ID) = 'ALL' OR p_Org_ID IS NULL) THEN
135: SELECT 1
136: INTO l_Return_Value
137: FROM pa_projects_all prj
138: , pji_org_denorm pjd
139: WHERE
140: 1=1
141: AND project_id = p_Project_ID

Line 148: FROM pa_projects_all prj

144: AND prj.org_id = p_Org_ID;
145: ELSE
146: SELECT 1
147: INTO l_Return_Value
148: FROM pa_projects_all prj
149: , pji_org_denorm pjd
150: WHERE
151: 1=1
152: AND project_id = p_Project_ID

Line 178: pa_projects_all prj

174: IF NOT (UPPER(p_Org_ID) = 'ALL' OR p_Org_ID IS NULL) THEN
175:
176: SELECT 1 into l_Return_Value
177: FROM
178: pa_projects_all prj
179: , pji_org_denorm pjd
180: , (SELECT project_id
181: FROM pji_project_classes
182: WHERE class_category = '$PROJECT_TYPE$'||p_Project_Type) PJC

Line 195: pa_projects_all prj

191: ELSE
192:
193: SELECT 1 into l_Return_Value
194: FROM
195: pa_projects_all prj
196: ,pji_org_denorm pjd
197: , (SELECT project_id
198: FROM pji_project_classes
199: WHERE class_category = '$PROJECT_TYPE$'||p_Project_type) PJC