APPS.PA_USER_ATTR_PUB dependencies on EGO_OBJ_AG_ASSOCS_B

Line 502: FROM EGO_OBJ_AG_ASSOCS_B

498:
499: CURSOR get_assoc_date
500: IS
501: SELECT creation_date
502: FROM EGO_OBJ_AG_ASSOCS_B
503: WHERE association_id = p_association_id;
504:
505: CURSOR get_max_ext_date
506: IS

Line 1002: FROM EGO_OBJ_AG_ASSOCS_B assocs,

998: SELECT 'Y'
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');

Line 1014: FROM EGO_OBJ_AG_ASSOCS_B assocs,

1010: SELECT 'Y'
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');

Line 1140: FROM EGO_OBJ_AG_ASSOCS_B assocs,

1136: SELECT 'Y'
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');