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 1038: from jtf_cal_shift_constructs

1034: select shift_construct_id,
1035: begin_time start_constr,
1036: end_time end_constr,
1037: availability_type_code
1038: from jtf_cal_shift_constructs
1039: where shift_id = p_shift_id
1040: and ((start_date_active <=p_day and end_date_active IS NULL) /* bug# 2408759 */
1041: or (p_day between start_date_active and end_date_active))
1042: and (

Line 1614: from jtf_cal_shift_constructs

1610: attribute12,
1611: attribute13,
1612: attribute14,
1613: attribute15
1614: from jtf_cal_shift_constructs
1615: where shift_id = p_shift_id
1616: and ((start_date_active <=p_day and end_date_active IS NULL) /* bug# 2408759 */
1617: or (p_day between start_date_active and end_date_active))
1618: -- and unit_of_time_value = p_uot_value;

Line 2398: from jtf_cal_shift_constructs

2394: select shift_construct_id,
2395: begin_time shift_begin_time,
2396: end_time shift_end_time,
2397: availability_type_code
2398: from jtf_cal_shift_constructs
2399: where shift_id = p_shift_id
2400: and ((start_date_active <=p_day and end_date_active IS NULL) /* bug# 2408759 */
2401: or (p_day between start_date_active and end_date_active))
2402: and