APPS.EGO_EXT_FWK_PUB dependencies on EGO_ATTR_GROUPS_V

Line 1000: FROM EGO_ATTR_GROUPS_V

996: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
997:
998: DELETE FROM EGO_ATTR_GROUP_DL
999: WHERE ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1000: FROM EGO_ATTR_GROUPS_V
1001: WHERE APPLICATION_ID = p_application_id
1002: AND ATTR_GROUP_TYPE = p_attr_group_type
1003: AND ATTR_GROUP_NAME = p_attr_group_name);
1004:

Line 8371: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;

8367:
8368: --Checking if the variant attribute group trying to be associated has attributes in it, if not raise exception
8369: SELECT Nvl(VARIANT, 'N')
8370: INTO l_variant_flag
8371: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;
8372:
8373: SELECT Count(1)
8374: INTO l_attr_count
8375: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV

Line 8375: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV

8371: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;
8372:
8373: SELECT Count(1)
8374: INTO l_attr_count
8375: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV
8376: WHERE AGV.APPLICATION_ID = AV.APPLICATION_ID
8377: AND AGV.ATTR_GROUP_TYPE = AV.ATTR_GROUP_TYPE
8378: AND AGV.ATTR_GROUP_NAME = AV.ATTR_GROUP_NAME
8379: AND AGV.ATTR_GROUP_ID = p_attr_group_id;

Line 8398: FROM EGO_ATTR_GROUPS_V AGV

8394: WHERE OBJECT_ID = p_object_id
8395: AND CLASSIFICATION_CODE = p_classification_code
8396: AND VARIANT = 'Y'
8397: AND EXISTS (SELECT 'X'
8398: FROM EGO_ATTR_GROUPS_V AGV
8399: WHERE AGV.ATTR_GROUP_ID = p_attr_group_id
8400: AND AGV.VARIANT = 'Y');
8401:
8402: -- special handling for variant attribute groups