APPS.FEM_WEBADI_FEM_BAL_UTILS_PVT dependencies on FEM_CAL_PERIODS_ATTR

Line 70: select date_assign_value into l_cal_period_end_date from fem_cal_periods_attr

66: x_msg_data varchar2(100);
67:
68: begin
69:
70: select date_assign_value into l_cal_period_end_date from fem_cal_periods_attr
71: where cal_period_id = P_CAL_PERIOD_ID
72: and attribute_id = (
73: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v
74: where a.attribute_id = v.attribute_id

Line 78: select number_assign_value into l_cal_period_number from FEM_CAL_PERIODS_ATTR

74: where a.attribute_id = v.attribute_id
75: and a.attribute_varchar_label = 'CAL_PERIOD_END_DATE'
76: and v.default_version_flag = 'Y' );
77:
78: select number_assign_value into l_cal_period_number from FEM_CAL_PERIODS_ATTR
79: where cal_period_id = P_CAL_PERIOD_ID
80: and attribute_id = (
81: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v
82: where a.attribute_id = v.attribute_id