11159:
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,
11184: AND attributes3.ATTRIBUTE_VARCHAR_LABEL='ADJ_PERIOD_FLAG';
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