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 dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 512: from jtf_cal_resource_assign a,

508: begin --(1)
509: -- get the primary calendar for a resource on the given date
510: select a.calendar_id,b.start_date_active
511: into l_calendar_id,l_calendar_start_date
512: from jtf_cal_resource_assign a,
513: jtf_calendars_b b
514: where a.resource_id = p_resource_id
515: and a.resource_type_code = p_resource_type
516: and a.calendar_id = b.calendar_id

Line 1039: from jtf_cal_resource_assign a,

1035: --
1036: BEGIN --(1)
1037: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1038: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1039: from jtf_cal_resource_assign a,
1040: jtf_calendars_vl b
1041: where a.resource_id = p_resource_id
1042: and a.resource_type_code = p_resource_type
1043: and a.calendar_id = b.calendar_id

Line 1453: from jtf_cal_resource_assign

1449: (p_resource_id number,
1450: p_resource_type varchar2,p_shift_date DATE) IS
1451: -- added p_shift_date bug 1355824
1452: select start_date_time
1453: from jtf_cal_resource_assign
1454: where resource_id = p_resource_id
1455: and resource_type_code = p_resource_type
1456: and primary_calendar_flag = 'Y'
1457: and (( p_shift_date >= trunc(start_date_time) and end_date_time IS NULL )

Line 1554: from jtf_cal_resource_assign a,

1550: --
1551: begin --(1)
1552: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1553: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1554: from jtf_cal_resource_assign a,
1555: jtf_calendars_vl b
1556: where a.resource_id = p_resource_id
1557: and a.resource_type_code = p_resource_type
1558: and a.calendar_id = b.calendar_id

Line 2215: from jtf_cal_resource_assign a,

2211: --
2212: begin --(1)
2213: select a.calendar_id,b.calendar_name,b.start_date_active
2214: into l_calendar_id,l_calendar_name,l_calendar_start_date
2215: from jtf_cal_resource_assign a,
2216: jtf_calendars_vl b
2217: where a.resource_id = p_resource_id
2218: and a.resource_type_code = p_resource_type
2219: and a.calendar_id = b.calendar_id