DBA Data[Home] [Help]

APPS.FEM_DIM_UTILS_PVT dependencies on FEM_CAL_PERIODS_ATTR

Line 11164: fem_cal_periods_attr startDate,

11160:
11161:
11162: CURSOR chk_ovrlp IS SELECT a.CAL_PERIOD_NAME
11163: FROM fem_cal_periods_vl a,
11164: fem_cal_periods_attr startDate,
11165: fem_cal_periods_attr endDate,
11166: fem_cal_periods_attr adjFlag,
11167: fem_dim_attributes_vl attributes1,
11168: fem_dim_attributes_vl attributes2,

Line 11165: fem_cal_periods_attr endDate,

11161:
11162: CURSOR chk_ovrlp IS SELECT a.CAL_PERIOD_NAME
11163: FROM fem_cal_periods_vl a,
11164: fem_cal_periods_attr startDate,
11165: fem_cal_periods_attr endDate,
11166: fem_cal_periods_attr adjFlag,
11167: fem_dim_attributes_vl attributes1,
11168: fem_dim_attributes_vl attributes2,
11169: fem_dim_attributes_vl attributes3

Line 11166: fem_cal_periods_attr adjFlag,

11162: CURSOR chk_ovrlp IS SELECT a.CAL_PERIOD_NAME
11163: FROM fem_cal_periods_vl a,
11164: fem_cal_periods_attr startDate,
11165: fem_cal_periods_attr endDate,
11166: fem_cal_periods_attr adjFlag,
11167: fem_dim_attributes_vl attributes1,
11168: fem_dim_attributes_vl attributes2,
11169: fem_dim_attributes_vl attributes3
11170: WHERE a.CALENDAR_ID=p_calendar_id

Line 11189: fem_cal_periods_attr b,

11185:
11186:
11187: CURSOR l_cur_period_csr IS SELECT a.cal_period_name
11188: FROM fem_cal_periods_vl a,
11189: fem_cal_periods_attr b,
11190: fem_dim_attributes_vl c
11191: WHERE a.calendar_id = p_calendar_id
11192: AND a.cal_period_id <> p_cal_period_id
11193: AND a.dimension_group_id = p_dimension_group_id