[Home] [Help]
466: begin --(1)
467: -- get the primary calendar for a resource on the given date
468: select a.calendar_id,b.start_date_active
469: into l_calendar_id,l_calendar_start_date
470: from jtf_cal_resource_assign a,
471: jtf_calendars_b b
472: where a.resource_id = p_resource_id
473: and a.resource_type_code = p_resource_type
474: and a.calendar_id = b.calendar_id
993: --
994: BEGIN --(1)
995: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
996: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
997: from jtf_cal_resource_assign a,
998: jtf_calendars_vl b
999: where a.resource_id = p_resource_id
1000: and a.resource_type_code = p_resource_type
1001: and a.calendar_id = b.calendar_id
1404: (p_resource_id number,
1405: p_resource_type varchar2,p_shift_date DATE) IS
1406: -- added p_shift_date bug 1355824
1407: select start_date_time
1408: from jtf_cal_resource_assign
1409: where resource_id = p_resource_id
1410: and resource_type_code = p_resource_type
1411: and primary_calendar_flag = 'Y'
1412: and (( p_shift_date >= trunc(start_date_time) and end_date_time IS NULL )
1505: --
1506: begin --(1)
1507: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1508: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1509: from jtf_cal_resource_assign a,
1510: jtf_calendars_vl b
1511: where a.resource_id = p_resource_id
1512: and a.resource_type_code = p_resource_type
1513: and a.calendar_id = b.calendar_id
2161: --
2162: begin --(1)
2163: select a.calendar_id,b.calendar_name,b.start_date_active
2164: into l_calendar_id,l_calendar_name,l_calendar_start_date
2165: from jtf_cal_resource_assign a,
2166: jtf_calendars_vl b
2167: where a.resource_id = p_resource_id
2168: and a.resource_type_code = p_resource_type
2169: and a.calendar_id = b.calendar_id