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_GROUPS_B

Line 396: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur

392: -- These workflow local user role records have to be inactivated.
393:
394: CURSOR c_grp_wf_ur_del IS
395: SELECT grp.group_id, grp.start_date_active, grp.end_date_active
396: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur
397: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) < l_sysdate
398: AND ((wlur.role_orig_system_id = grp.group_id
399: AND wlur.role_orig_system = l_grp_orig_system
400: AND wlur.role_name = l_grp_orig_system||':'||to_char(grp.group_id))

Line 456: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur

452: -- These workflow user role records have to be updated with new values.
453:
454: CURSOR c_grp_wf_ur_upd IS
455: SELECT grp.group_id, grp.start_date_active, grp.end_date_active
456: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur
457: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
458: AND ((wlur.role_orig_system_id = grp.group_id
459: AND wlur.role_orig_system = l_grp_orig_system
460: AND wlur.role_name = l_grp_orig_system||':'||to_char(grp.group_id))

Line 1095: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp

1091: mem.resource_id, mem.group_id
1092: ,greatest (ext.start_date_active, grp.start_date_active) m_start_date_active
1093: ,least (NVL (grp.end_date_active, l_fnd_date) ,
1094: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1095: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp
1096: WHERE mem.resource_id = ext.resource_id
1097: AND mem.group_id = grp.group_id
1098: AND ext.category IN ('OTHER','TBH')
1099: AND ext.resource_name IS NOT NULL

Line 1123: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp

1119: mem.resource_id, mem.group_id, ext.category, ext.resource_name
1120: ,greatest (ext.start_date_active, grp.start_date_active) m_start_date_active
1121: ,least (NVL (grp.end_date_active, l_fnd_date) ,
1122: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1123: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp
1124: WHERE mem.resource_id = ext.resource_id
1125: AND mem.group_id = grp.group_id
1126: AND ext.category IN ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
1127: AND NVL (mem.delete_flag,'N') <> 'Y'

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

1379: SELECT mem.team_resource_id group_id, mem.team_id
1380: ,greatest (team.start_date_active, grp.start_date_active) m_start_date_active
1381: ,least (NVL (team.end_date_active, l_fnd_date) ,
1382: NVL (grp.end_date_active, l_fnd_date)) m_end_date_active
1383: FROM jtf_rs_groups_b grp, jtf_rs_team_members mem, jtf_rs_teams_b team
1384: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1385: AND mem.team_resource_id = grp.group_id
1386: AND mem.resource_type = 'GROUP'
1387: AND mem.team_id = team.team_id