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.CAC_VIEW_ACC_DAILY_VIEW_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 437: FROM jtf_rs_resource_extns rs

433: RETURN VARCHAR2
434: IS
435: CURSOR c_attendees IS
436: SELECT source_first_name||' '||source_last_name attendee_name
437: FROM jtf_rs_resource_extns rs
438: , jtf_task_all_assignments jta
439: WHERE jta.resource_type_code = 'RS_EMPLOYEE'
440: AND jta.assignee_role = 'ASSIGNEE'
441: AND jta.task_id = p_task_id

Line 446: FROM jtf_rs_resource_extns rs

442: AND rs.category = 'EMPLOYEE'
443: AND rs.resource_id = jta.resource_id
444: UNION
445: SELECT source_first_name||' '||source_last_name attendee_name
446: FROM jtf_rs_resource_extns rs
447: , jtf_rs_group_members rg
448: , jtf_task_all_assignments jta
449: WHERE jta.resource_type_code = 'RS_GROUP'
450: AND jta.assignee_role = 'ASSIGNEE'

Line 456: FROM jtf_rs_resource_extns rs

452: AND rg.group_id = jta.resource_id
453: AND rs.resource_id = rg.resource_id
454: UNION
455: SELECT source_first_name||' '||source_last_name attendee_name
456: FROM jtf_rs_resource_extns rs
457: , jtf_rs_team_members rt_ind
458: , jtf_task_all_assignments jta
459: WHERE jta.resource_type_code = 'RS_TEAM'
460: AND jta.assignee_role = 'ASSIGNEE'

Line 467: FROM jtf_rs_resource_extns rs

463: AND rt_ind.resource_type = 'INDIVIDUAL'
464: AND rs.resource_id = rt_ind.team_resource_id
465: UNION
466: SELECT source_first_name||' '||source_last_name attendee_name
467: FROM jtf_rs_resource_extns rs
468: , jtf_rs_group_members rg
469: , jtf_rs_team_members rt_grp
470: , jtf_task_all_assignments jta
471: WHERE jta.resource_type_code = 'RS_TEAM'