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 1003: FROM EGO_OBJ_AG_ASSOCS_B assocs,

999: SELECT 'Y'
1000: FROM DUAL
1001: WHERE EXISTS
1002: (SELECT classification_code
1003: FROM EGO_OBJ_AG_ASSOCS_B assocs,
1004: FND_OBJECTS obj
1005: WHERE assocs.classification_code = 'CLASS_CATEGORY:'||to_char(c_class_category_id)
1006: AND assocs.object_id = obj.object_id
1007: AND obj.obj_name = 'PA_PROJECTS');

Line 1015: FROM EGO_OBJ_AG_ASSOCS_B assocs,

1011: SELECT 'Y'
1012: FROM DUAL
1013: WHERE EXISTS
1014: (SELECT classification_code
1015: FROM EGO_OBJ_AG_ASSOCS_B assocs,
1016: FND_OBJECTS obj
1017: WHERE assocs.classification_code = 'CLASS_CODE:'||to_char(c_class_code_id)
1018: AND assocs.object_id = obj.object_id
1019: AND obj.obj_name = 'PA_PROJECTS');

Line 1141: FROM EGO_OBJ_AG_ASSOCS_B assocs,

1137: SELECT 'Y'
1138: FROM DUAL
1139: WHERE EXISTS
1140: (SELECT classification_code
1141: FROM EGO_OBJ_AG_ASSOCS_B assocs,
1142: FND_OBJECTS obj
1143: WHERE assocs.classification_code = 'PROJECT_TYPE:'||to_char(c_project_type_id)
1144: AND assocs.object_id = obj.object_id
1145: AND obj.obj_name = 'PA_PROJECTS');