[Home] [Help]
323: select shift_construct_id,
324: begin_time start_constr,
325: end_time end_constr,
326: availability_type_code
327: from jtf_cal_shift_constructs
328: where shift_id = p_shift_id
329: --
330: --Modified condition to take care first Day of week for Bug 1342982
331: --
866: select shift_construct_id,
867: begin_time start_constr,
868: end_time end_constr,
869: availability_type_code
870: from jtf_cal_shift_constructs
871: where shift_id = p_shift_id
872: --
873: --Modified condition to take care first Day of week for Bug 1342982
874: --
1368: attribute12,
1369: attribute13,
1370: attribute14,
1371: attribute15
1372: from jtf_cal_shift_constructs
1373: where shift_id = p_shift_id
1374: --
1375: --Modified condition to take care first Day of week for Bug 1342982
1376: --
1988: select shift_construct_id,
1989: begin_time shift_begin_time,
1990: end_time shift_end_time,
1991: availability_type_code
1992: from jtf_cal_shift_constructs
1993: where shift_id = p_shift_id
1994: --
1995: --Modified condition to take care first Day of week for Bug 1342982
1996: --