999: FROM DUAL
1000: WHERE EXISTS
1001: (SELECT classification_code
1002: FROM EGO_OBJ_AG_ASSOCS_B assocs,
1003: FND_OBJECTS obj
1004: WHERE assocs.classification_code = 'CLASS_CATEGORY:'||to_char(c_class_category_id)
1005: AND assocs.object_id = obj.object_id
1006: AND obj.obj_name = 'PA_PROJECTS');
1007:
1011: FROM DUAL
1012: WHERE EXISTS
1013: (SELECT classification_code
1014: FROM EGO_OBJ_AG_ASSOCS_B assocs,
1015: FND_OBJECTS obj
1016: WHERE assocs.classification_code = 'CLASS_CODE:'||to_char(c_class_code_id)
1017: AND assocs.object_id = obj.object_id
1018: AND obj.obj_name = 'PA_PROJECTS');
1019:
1137: FROM DUAL
1138: WHERE EXISTS
1139: (SELECT classification_code
1140: FROM EGO_OBJ_AG_ASSOCS_B assocs,
1141: FND_OBJECTS obj
1142: WHERE assocs.classification_code = 'PROJECT_TYPE:'||to_char(c_project_type_id)
1143: AND assocs.object_id = obj.object_id
1144: AND obj.obj_name = 'PA_PROJECTS');
1145: