APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on FEM_CAL_PERIODS_ATTR

Line 2669: select date_assign_value into l_cal_period_end_date from fem_cal_periods_attr

2665:
2666:
2667: ------------------------ Deriving Cal Period End Date -------------------
2668:
2669: select date_assign_value into l_cal_period_end_date from fem_cal_periods_attr
2670: where cal_period_id = P_CAL_PERIOD
2671: and attribute_id = (
2672: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v
2673: where a.attribute_id = v.attribute_id

Line 2679: select number_assign_value into l_cal_period_number from FEM_CAL_PERIODS_ATTR

2675: and v.default_version_flag = 'Y' );
2676:
2677: ------------------------ Deriving Cal Period Number ---------------------
2678:
2679: select number_assign_value into l_cal_period_number from FEM_CAL_PERIODS_ATTR
2680: where cal_period_id = P_CAL_PERIOD
2681: and attribute_id = (
2682: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v
2683: where a.attribute_id = v.attribute_id