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 1302: FROM PA_VALID_CATEGORIES_V

1298:
1299: CURSOR check_valid_catg_csr(c_class_category VARCHAR2, c_object_type_id NUMBER)
1300: IS
1301: SELECT 'Y'
1302: FROM PA_VALID_CATEGORIES_V
1303: WHERE class_category = c_class_category
1304: AND object_type_id = c_object_type_id;
1305:
1306: l_dummy VARCHAR2(1);

Line 1398: FROM PA_VALID_CATEGORIES vc,

1394:
1395: CURSOR C2(c_object_id NUMBER, c_class_category VARCHAR2)
1396: IS
1397: SELECT 1
1398: FROM PA_VALID_CATEGORIES vc,
1399: PA_PROJECTS_ALL ppa,
1400: PA_PROJECT_TYPES_ALL ppta
1401: WHERE vc.mandatory_flag = 'Y'
1402: AND vc.class_category = c_class_category

Line 1677: FROM PA_VALID_CATEGORIES_V vc,

1673: /*
1674: CURSOR C2
1675: IS
1676: SELECT total_100_percent_flag
1677: FROM PA_VALID_CATEGORIES_V vc,
1678: PA_PROJECTS_ALL ppa,
1679: PA_PROJECT_TYPES_ALL ppta
1680: WHERE ppa.project_id = p_object_id
1681: AND ppa.project_type = ppta.project_type