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.

[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on JTF_RS_TEAMS_B

Line 113: FROM jtf_rs_teams_b team, wf_local_user_roles wlur

109: -- These workflow local user role records have to be inactivated.
110:
111: CURSOR c_team_wf_ur_del IS
112: SELECT team.team_id, team.start_date_active, team.end_date_active
113: FROM jtf_rs_teams_b team, wf_local_user_roles wlur
114: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) < l_sysdate
115: AND wlur.role_orig_system_id = team.team_id
116: AND wlur.role_orig_system = l_team_orig_system
117: AND wlur.role_name = l_team_orig_system||':'||to_char(team.team_id)

Line 165: FROM jtf_rs_teams_b team, wf_local_user_roles wlur

161: -- These workflow user role records have to be updated with new values.
162:
163: CURSOR c_team_wf_ur_upd IS
164: SELECT team.team_id, team.start_date_active, team.end_date_active
165: FROM jtf_rs_teams_b team, wf_local_user_roles wlur
166: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
167: AND wlur.role_orig_system_id = team.team_id
168: AND wlur.role_orig_system = l_team_orig_system
169: AND wlur.role_name = l_team_orig_system||':'||to_char(team.team_id)

Line 1427: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team

1423: SELECT mem.team_resource_id resource_id, mem.team_id
1424: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1425: ,least (NVL (team.end_date_active, l_fnd_date) ,
1426: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1427: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1428: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1429: AND mem.team_resource_id = ext.resource_id
1430: AND mem.resource_type = 'INDIVIDUAL'
1431: AND mem.team_id = team.team_id

Line 1455: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team

1451: SELECT mem.team_resource_id resource_id, mem.team_id, ext.category, ext.resource_name
1452: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1453: ,least (NVL (team.end_date_active, l_fnd_date) ,
1454: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1455: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1456: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1457: AND mem.team_resource_id = ext.resource_id
1458: AND mem.resource_type = 'INDIVIDUAL'
1459: AND mem.team_id = team.team_id

Line 1481: FROM jtf_rs_groups_b grp, jtf_rs_team_members mem, jtf_rs_teams_b team

1477: SELECT mem.team_resource_id group_id, mem.team_id
1478: ,greatest (team.start_date_active, grp.start_date_active) m_start_date_active
1479: ,least (NVL (team.end_date_active, l_fnd_date) ,
1480: NVL (grp.end_date_active, l_fnd_date)) m_end_date_active
1481: FROM jtf_rs_groups_b grp, jtf_rs_team_members mem, jtf_rs_teams_b team
1482: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1483: AND mem.team_resource_id = grp.group_id
1484: AND mem.resource_type = 'GROUP'
1485: AND mem.team_id = team.team_id