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_PROJECTS_MAINT_UTILS dependencies on PA_VALID_CATEGORIES_V

Line 1289: FROM PA_VALID_CATEGORIES_V

1285:
1286: CURSOR check_valid_catg_csr(c_class_category VARCHAR2, c_object_type_id NUMBER)
1287: IS
1288: SELECT 'Y'
1289: FROM PA_VALID_CATEGORIES_V
1290: WHERE class_category = c_class_category
1291: AND object_type_id = c_object_type_id;
1292:
1293: l_dummy VARCHAR2(1);

Line 1385: FROM PA_VALID_CATEGORIES vc,

1381:
1382: CURSOR C2(c_object_id NUMBER, c_class_category VARCHAR2)
1383: IS
1384: SELECT 1
1385: FROM PA_VALID_CATEGORIES vc,
1386: PA_PROJECTS_ALL ppa,
1387: PA_PROJECT_TYPES_ALL ppta
1388: WHERE vc.mandatory_flag = 'Y'
1389: AND vc.class_category = c_class_category

Line 1664: FROM PA_VALID_CATEGORIES_V vc,

1660: /*
1661: CURSOR C2
1662: IS
1663: SELECT total_100_percent_flag
1664: FROM PA_VALID_CATEGORIES_V vc,
1665: PA_PROJECTS_ALL ppa,
1666: PA_PROJECT_TYPES_ALL ppta
1667: WHERE ppa.project_id = p_object_id
1668: AND ppa.project_type = ppta.project_type