APPS.GCS_HIERARCHIES_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 1264: fem_dim_attr_versions_b fdavb

1260: gcs_cons_eng_run_dtls rd,
1261: fem_cal_periods_attr cpa,
1262: gcs_cons_relationships cr,
1263: fem_dim_attributes_b fdab,
1264: fem_dim_attr_versions_b fdavb
1265: WHERE r.hierarchy_id = p_hierarchy_id
1266: AND r.run_entity_id = p_parent_id
1267: AND rd.run_name = r.run_name
1268: AND rd.consolidation_entity_id = p_parent_id

Line 2097: fem_dim_attr_versions_b fdavb_type

2093: SELECT r.child_entity_id, r.start_date, r.end_date
2094: FROM gcs_cons_relationships r,
2095: fem_entities_attr fea_type,
2096: fem_dim_attributes_b fdab_type,
2097: fem_dim_attr_versions_b fdavb_type
2098: WHERE r.hierarchy_id = p_hier_id
2099: AND r.start_date > p_removal_date
2100: AND fea_type.entity_id = r.child_entity_id
2101: AND fea_type.attribute_id = fdab_type.attribute_id

Line 2176: fem_dim_attr_versions_b fdavb

2172: 'Y',
2173: 'Y'
2174: FROM fem_entities_attr fea,
2175: fem_dim_attributes_b fdab,
2176: fem_dim_attr_versions_b fdavb
2177: WHERE fea.entity_id = l_child_id
2178: AND fea.attribute_id = fdab.attribute_id
2179: AND fea.version_id = fdavb.version_id
2180: AND fdab.attribute_varchar_label IN

Line 2235: fem_dim_attr_versions_b fdavb,

2231: INTO l_data_type_name, l_dataset_code, l_fem_balance_type
2232: FROM gcs_data_type_codes_b gdtcb,
2233: gcs_data_type_codes_tl gdtctl,
2234: fem_dim_attributes_b fdab,
2235: fem_dim_attr_versions_b fdavb,
2236: fem_datasets_attr fda
2237: WHERE gdtcb.source_dataset_code = fda.dataset_code
2238: AND gdtcb.data_type_id = gdtctl.data_type_id
2239: AND gdtctl.language = userenv('LANG')

Line 2253: fem_dim_attr_versions_b fdavb

2249: SELECT fda.dim_attribute_numeric_member
2250: INTO l_budget_id
2251: FROM fem_datasets_attr fda,
2252: fem_dim_attributes_b fdab,
2253: fem_dim_attr_versions_b fdavb
2254: WHERE fda.attribute_id = fdab.attribute_id
2255: AND fdab.attribute_id = fdavb.attribute_id
2256: AND fda.version_id = fdavb.version_id
2257: AND fdavb.default_version_flag = 'Y'

Line 2267: fem_dim_attr_versions_b fdavb

2263: SELECT fda.dim_attribute_numeric_member
2264: INTO l_encumbrance_type_id
2265: FROM fem_datasets_attr fda,
2266: fem_dim_attributes_b fdab,
2267: fem_dim_attr_versions_b fdavb
2268: WHERE fda.attribute_id = fdab.attribute_id
2269: AND fdab.attribute_id = fdavb.attribute_id
2270: AND fda.version_id = fdavb.version_id
2271: AND fdavb.default_version_flag = 'Y'

Line 2437: fem_dim_attr_versions_b fdavb,

2433: INTO l_data_type_info
2434: FROM gcs_data_type_codes_b gdtcb,
2435: gcs_data_type_codes_tl gdtctl,
2436: fem_dim_attributes_b fdab,
2437: fem_dim_attr_versions_b fdavb,
2438: fem_datasets_attr fda
2439: WHERE gdtcb.source_dataset_code = fda.dataset_code
2440: AND gdtcb.data_type_id = gdtctl.data_type_id
2441: AND gdtctl.language = userenv('LANG')

Line 2468: fem_dim_attr_versions_b fdavb

2464: SELECT fda.dim_attribute_numeric_member
2465: INTO l_budget_id
2466: FROM fem_datasets_attr fda,
2467: fem_dim_attributes_b fdab,
2468: fem_dim_attr_versions_b fdavb
2469: WHERE fda.attribute_id = fdab.attribute_id
2470: AND fdab.attribute_id = fdavb.attribute_id
2471: AND fda.version_id = fdavb.version_id
2472: AND fdavb.default_version_flag = 'Y'

Line 2482: fem_dim_attr_versions_b fdavb

2478: SELECT fda.dim_attribute_numeric_member
2479: INTO l_encumbrance_type_id
2480: FROM fem_datasets_attr fda,
2481: fem_dim_attributes_b fdab,
2482: fem_dim_attr_versions_b fdavb
2483: WHERE fda.attribute_id = fdab.attribute_id
2484: AND fdab.attribute_id = fdavb.attribute_id
2485: AND fda.version_id = fdavb.version_id
2486: AND fdavb.default_version_flag = 'Y'