DBA Data[Home] [Help]

APPS.CAC_VIEW_ACC_DAILY_VIEW_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 447: , jtf_rs_group_members rg

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'
451: AND jta.task_id = p_task_id

Line 468: , jtf_rs_group_members rg

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'
472: AND jta.assignee_role = 'ASSIGNEE'