APPS.GCS_PERIOD_INIT_PKG dependencies on FEM_ENTITIES_ATTR

Line 95: FROM FEM_ENTITIES_ATTR

91:
92: IF (l_target_entity_code = 'PARENT') THEN
93: SELECT nvl(decode(dim_attribute_varchar_member, 'E', 'Y', 'N'), 'N')
94: INTO l_is_elim_entity
95: FROM FEM_ENTITIES_ATTR
96: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
97: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
98: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
99: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id

Line 107: FROM fem_entities_attr oper_fea,

103:
104: IF (l_is_elim_entity = 'Y') THEN
105: SELECT oper_fea.dim_attribute_numeric_member
106: INTO l_query_entity_id
107: FROM fem_entities_attr oper_fea,
108: fem_entities_attr elim_fea
109: WHERE elim_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
110: ('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
111: AND elim_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info

Line 108: fem_entities_attr elim_fea

104: IF (l_is_elim_entity = 'Y') THEN
105: SELECT oper_fea.dim_attribute_numeric_member
106: INTO l_query_entity_id
107: FROM fem_entities_attr oper_fea,
108: fem_entities_attr elim_fea
109: WHERE elim_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
110: ('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
111: AND elim_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info
112: ('ENTITY_ID-ELIMINATION_ENTITY').version_id

Line 498: FROM FEM_ENTITIES_ATTR

494:
495: -- determine if the entity is an elimination entity
496: SELECT nvl(decode(dim_attribute_varchar_member, 'E', 'Y', 'N'), 'N')
497: INTO l_is_elim_entity
498: FROM FEM_ENTITIES_ATTR
499: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
500: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
501: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
502: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id