APPS.GCS_CONS_ENG_UTILITY_PKG dependencies on FEM_ENTITIES_ATTR

Line 800: FROM fem_entities_attr fea

796: -- Bugfix 3870959 : Extract Appropriate Entity based off of Target Entity Code
797: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_number).target_entity_code = 'ELIMINATION') THEN
798: SELECT fea.dim_attribute_numeric_member
799: INTO l_entity_id
800: FROM fem_entities_attr fea
801: WHERE fea.entity_id = cons_entity_wf_info.consolidation_entity
802: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
803: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
804: ELSE

Line 808: FROM fem_entities_attr fea

804: ELSE
805: BEGIN
806: SELECT fea.dim_attribute_numeric_member
807: INTO l_entity_id
808: FROM fem_entities_attr fea
809: WHERE fea.entity_id = cons_entity_wf_info.consolidation_entity
810: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id
811: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
812: EXCEPTION

Line 1212: fem_entities_attr fea,

1208: FROM gcs_cons_relationships gcr,
1209: gcs_entity_cons_attrs geca,
1210: gcs_elim_rule_rels gerr,
1211: gcs_dataset_codes gdc,
1212: fem_entities_attr fea,
1213: gcs_elim_rules_b grb,
1214: gcs_categories_b gcatb
1215: WHERE gcr.hierarchy_id = p_hierarchy_id
1216: AND gcr.parent_entity_id = p_cons_entity_id

Line 1415: FROM fem_entities_attr

1411: IF (v_cons_entity_rules.target_entity_code = 'ELIMINATION') THEN
1412: BEGIN
1413: SELECT dim_attribute_numeric_member
1414: INTO l_parameter_list.rp_parameters.parentEntity
1415: FROM fem_entities_attr
1416: WHERE entity_id = v_cons_entity_rules.parent_entity_id
1417: AND attribute_id = l_oper_entity_attr
1418: AND version_id = l_oper_entity_version;
1419: EXCEPTION

Line 1426: FROM fem_entities_attr

1422: END;
1423: ELSIF (v_cons_entity_rules.target_entity_code = 'PARENT') THEN
1424: SELECT dim_attribute_numeric_member
1425: INTO l_parameter_list.rp_parameters.parentEntity
1426: FROM fem_entities_attr
1427: WHERE entity_id = v_cons_entity_rules.parent_entity_id
1428: AND attribute_id = l_oper_entity_attr
1429: AND version_id = l_oper_entity_version;
1430: END IF;

Line 1477: FROM fem_entities_attr

1473: BEGIN
1474: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_num).target_entity_code = 'ELIMINATION') THEN
1475: SELECT dim_attribute_numeric_member
1476: INTO l_tgt_entity_id
1477: FROM fem_entities_attr
1478: WHERE entity_id = cons_entity_wf_info.consolidation_entity
1479: AND attribute_id = l_elim_entity_attr
1480: AND version_id = l_elim_entity_version;
1481: ELSE

Line 1484: FROM fem_entities_attr

1480: AND version_id = l_elim_entity_version;
1481: ELSE
1482: SELECT dim_attribute_numeric_member
1483: INTO l_tgt_entity_id
1484: FROM fem_entities_attr
1485: WHERE entity_id = cons_entity_wf_info.consolidation_entity
1486: AND attribute_id = l_oper_entity_attr
1487: AND version_id = l_oper_entity_version;
1488: END IF;

Line 1581: FROM fem_entities_attr

1577: l_parameter_list.bp_post_xlate := 'N';
1578:
1579: SELECT dim_attribute_numeric_member
1580: INTO l_entity_id
1581: FROM fem_entities_attr
1582: WHERE entity_id = cons_entity_wf_info.consolidation_entity
1583: AND attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
1584: AND version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1585: