DBA Data[Home] [Help]

APPS.GCS_IMPACT_WRITER_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 66: fem_cal_periods_attr fcpa

62: p_bal_type_code VARCHAR2)
63: IS
64: SELECT gea.entity_id
65: FROM gcs_entities_attr gea,
66: fem_cal_periods_attr fcpa
67: WHERE gea.ledger_id = p_ledger_id
68: AND gea.data_type_code = DECODE(p_bal_type_code, 'A', 'ACTUAL', 'N/A')
69: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
70: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id

Line 251: fem_cal_periods_attr fcpa

247: SELECT object_definition_id
248: INTO l_her_obj_def_id
249: FROM fem_object_definition_b fodb,
250: fem_xdim_dimensions fxd,
251: fem_cal_periods_attr fcpa
252: WHERE fodb.object_id = fxd.default_mvs_hierarchy_obj_id
253: AND dimension_id = 8
254: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
255: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id