[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: --
908: select shift_construct_id,
909: begin_time start_constr,
910: end_time end_constr,
911: availability_type_code
912: from jtf_cal_shift_constructs
913: where shift_id = p_shift_id
914: --
915: --Modified condition to take care first Day of week for Bug 1342982
916: --
1413: attribute12,
1414: attribute13,
1415: attribute14,
1416: attribute15
1417: from jtf_cal_shift_constructs
1418: where shift_id = p_shift_id
1419: --
1420: --Modified condition to take care first Day of week for Bug 1342982
1421: --
2038: select shift_construct_id,
2039: begin_time shift_begin_time,
2040: end_time shift_end_time,
2041: availability_type_code
2042: from jtf_cal_shift_constructs
2043: where shift_id = p_shift_id
2044: --
2045: --Modified condition to take care first Day of week for Bug 1342982
2046: --