APPS.PA_CALENDAR_UTILS dependencies on JTF_CAL_SHIFT_CONSTRUCTS

Line 35: FROM JTF_CAL_SHIFT_CONSTRUCTS

31:
32: -- This cursor will select the work patern of the assigning shift to the calendar
33: -- Bug 2181241: Modified the rounding to be two decimals.
34: CURSOR C2 IS SELECT unit_of_time_value,round(SUM(end_time - begin_time)*24, 2) day_hours
35: FROM JTF_CAL_SHIFT_CONSTRUCTS
36: WHERE shift_id = l_t_shift_id
37: GROUP BY unit_of_time_value;
38:
39: BEGIN