APPS.EGO_USER_ATTRS_BULK_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 2488: FROM EGO_OBJ_AG_ASSOCS_B A

2484: WHERE UAI2.DATA_SET_ID = :data_set_id
2485: -- AND UAI2.DATA_SET_ID = UAI1.DATA_SET_ID -- Commenting for Bug 9336604
2486: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2487: AND NOT EXISTS (SELECT NULL
2488: FROM EGO_OBJ_AG_ASSOCS_B A
2489: WHERE A.ATTR_GROUP_ID = UAI2.ATTR_GROUP_ID
2490: AND A.OBJECT_ID = '||l_object_id||'
2491: AND A.CLASSIFICATION_CODE IN ('||p_related_class_codes_query||')';
2492: --R12C

Line 9281: FROM EGO_OBJ_AG_ASSOCS_B

9277: ELSE
9278: -- existing code which takes in the
9279: SELECT DATA_LEVEL_ID
9280: INTO l_ag_assoc_data_level_id
9281: FROM EGO_OBJ_AG_ASSOCS_B
9282: WHERE ATTR_GROUP_ID = l_attr_group_metadata_obj.ATTR_GROUP_ID
9283: AND ROWNUM = 1;
9284:
9285: FOR loop_dl_count IN l_dl_record.first .. l_dl_record.last LOOP

Line 10412: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL, '||

10408: ' ATTR_GROUP_TBL.ATTR_GROUP_ID, '||
10409: ' ASSOC_TBL.DATA_LEVEL '||
10410: ' '||l_inner_pk_cc_dl_col_list||' '||
10411: ' FROM EGO_FND_DSC_FLX_CTX_EXT ATTR_GROUP_TBL, '||
10412: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL, '||
10413: ' ('||p_target_entity_sql||') ENTITY '||
10414: ' WHERE '||
10415: ' ATTR_GROUP_TBL.DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type ';
10416: IF l_has_data_level_id THEN