APPS.GCS_UTILITY_PKG dependencies on FEM_ENTITIES_ATTR

Line 596: FROM FEM_ENTITIES_ATTR

592:
593: FUNCTION Get_Base_Org_Id(p_entity_id NUMBER) RETURN NUMBER IS
594: cursor getOrgId (cEntityId NUMBER) is
595: SELECT DIM_ATTRIBUTE_NUMERIC_MEMBER
596: FROM FEM_ENTITIES_ATTR
597: WHERE ENTITY_ID = cEntityId
598: AND VERSION_ID = g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION').version_id
599: AND ATTRIBUTE_ID = g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION').attribute_id;
600:

Line 678: FROM FEM_ENTITIES_ATTR

674:
675: --Gets the ENTITY_ID for the associated operating entity for this consolidation entity.
676: cursor getOpEntityId (cEntityId NUMBER) IS
677: SELECT DIM_ATTRIBUTE_NUMERIC_MEMBER
678: FROM FEM_ENTITIES_ATTR
679: WHERE ENTITY_ID = cEntityId
680: AND VERSION_ID = g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id
681: AND ATTRIBUTE_ID = g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
682:

Line 720: FROM FEM_ENTITIES_ATTR

716:
717: --Get entity_type
718: SELECT dim_attribute_varchar_member
719: INTO l_entity_type
720: FROM FEM_ENTITIES_ATTR
721: WHERE entity_id = l_entity_id
722: AND attribute_id = g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
723: AND version_id = g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id
724: AND value_set_id = g_gcs_dimension_info('ENTITY_ID').associated_value_set_id;

Line 742: --at fem_entities_attr

738: ELSE
739: --If entity is an elim entity, then get the consolidated entity
740: IF (l_entity_type = 'E') THEN
741: --Bugfix 5256700: Need to modify this code to handle case where child is owned multiple times. Will determine consolidation entity by looking
742: --at fem_entities_attr
743:
744: /* Commenting out original query
745: SELECT R.PARENT_ENTITY_ID
746: INTO c_entity_id

Line 763: FROM fem_entities_attr fea

759: END IF;
760:
761: SELECT fea.entity_id
762: INTO c_entity_id
763: FROM fem_entities_attr fea
764: WHERE fea.attribute_id = g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
765: AND fea.version_id = g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id
766: AND fea.dim_attribute_numeric_member = l_entity_id;
767: