eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CAL_SHIFT_CONSTRUCTS

Line 227: from jtf_cal_shift_constructs

223: select shift_construct_id,
224: begin_time start_constr,
225: end_time end_constr,
226: availability_type_code
227: from jtf_cal_shift_constructs
228: where shift_id = p_shift_id
229: and ((start_date_active <=p_day and end_date_active IS NULL) /* bug# 2408759 */
230: or (p_day between start_date_active and end_date_active))
231: and (

Line 1105: from jtf_cal_shift_constructs

1101: select shift_construct_id,
1102: begin_time start_constr,
1103: end_time end_constr,
1104: availability_type_code
1105: from jtf_cal_shift_constructs
1106: where shift_id = p_shift_id
1107: and ((start_date_active <=p_day and end_date_active IS NULL) /* bug# 2408759 */
1108: or (p_day between start_date_active and end_date_active))
1109: and (

Line 1681: from jtf_cal_shift_constructs

1677: attribute12,
1678: attribute13,
1679: attribute14,
1680: attribute15
1681: from jtf_cal_shift_constructs
1682: where shift_id = p_shift_id
1683: and ((start_date_active <=p_day and end_date_active IS NULL) /* bug# 2408759 */
1684: or (p_day between start_date_active and end_date_active))
1685: -- and unit_of_time_value = p_uot_value;

Line 2468: from jtf_cal_shift_constructs

2464: select shift_construct_id,
2465: begin_time shift_begin_time,
2466: end_time shift_end_time,
2467: availability_type_code
2468: from jtf_cal_shift_constructs
2469: where shift_id = p_shift_id
2470: and ((start_date_active <=p_day and end_date_active IS NULL) /* bug# 2408759 */
2471: or (p_day between start_date_active and end_date_active))
2472: and