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_USER_ATTR_PUB dependencies on PA_PROJECT_CLASSES

Line 64: FROM PA_PROJECT_CLASSES

60:
61: CURSOR check_category_removed(c_category VARCHAR2, c_old_project_id NUMBER, c_new_project_id NUMBER)
62: IS
63: SELECT class_category
64: FROM PA_PROJECT_CLASSES
65: WHERE project_id = c_old_project_id
66: AND class_category = c_category
67: AND class_category NOT IN
68: (SELECT class_category

Line 69: FROM PA_PROJECT_CLASSES

65: WHERE project_id = c_old_project_id
66: AND class_category = c_category
67: AND class_category NOT IN
68: (SELECT class_category
69: FROM PA_PROJECT_CLASSES
70: where project_id = c_new_project_id);
71:
72: CURSOR get_codes(c_category VARCHAR2, c_old_project_id NUMBER, c_new_project_id NUMBER)
73: IS

Line 75: FROM PA_PROJECT_CLASSES

71:
72: CURSOR get_codes(c_category VARCHAR2, c_old_project_id NUMBER, c_new_project_id NUMBER)
73: IS
74: SELECT class_code
75: FROM PA_PROJECT_CLASSES
76: WHERE project_id = c_old_project_id
77: AND class_category = c_category
78: MINUS
79: SELECT class_code

Line 80: FROM PA_PROJECT_CLASSES

76: WHERE project_id = c_old_project_id
77: AND class_category = c_category
78: MINUS
79: SELECT class_code
80: FROM PA_PROJECT_CLASSES
81: WHERE project_id = c_new_project_id
82: AND class_category = c_category;
83:
84: CURSOR get_category_id(c_category VARCHAR2)

Line 969: FROM PA_PROJECT_CLASSES

965: IS
966: CURSOR C1
967: IS
968: SELECT class_category, class_code
969: FROM PA_PROJECT_CLASSES
970: WHERE rowid = p_row_id;
971:
972: l_class_category VARCHAR2(30);
973: l_class_category_id NUMBER;