APPS.JTF_RS_CONC_WF_PUB dependencies on JTF_RS_TEAM_MEMBERS

Line 1309: FROM wf_local_user_roles wlur, jtf_rs_team_members mem

1305: -- resource team member records have been deleted (delete_flag Y).
1306:
1307: CURSOR c_wlur_team_mem_del IS
1308: SELECT wlur.user_orig_system, wlur.user_orig_system_id, mem.team_id
1309: FROM wf_local_user_roles wlur, jtf_rs_team_members mem
1310: WHERE NVL (mem.delete_flag,'N') = 'Y'
1311: AND wlur.role_orig_system = l_team_orig_system
1312: AND wlur.role_orig_system_id = mem.team_id
1313: AND wlur.role_name = l_team_orig_system ||':'|| mem.team_id

Line 1319: -- (jtf_rs_team_members) that are still not defined in workflow

1315: AND NVL(wlur.expiration_date, l_sysdate) >= l_sysdate;
1316:
1317:
1318: -- Select all active records from resource team members table
1319: -- (jtf_rs_team_members) that are still not defined in workflow
1320: -- user role table (wf_local_user_roles). This is for 'INDIVIDUAL'
1321: -- resource team members whose category is OTHER or TBH.
1322: -- These records have to be created in workflow user roles table.
1323:

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

1325: SELECT mem.team_resource_id resource_id, mem.team_id
1326: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1327: ,least (NVL (team.end_date_active, l_fnd_date) ,
1328: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1329: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1330: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1331: AND mem.team_resource_id = ext.resource_id
1332: AND mem.resource_type = 'INDIVIDUAL'
1333: AND mem.team_id = team.team_id

Line 1347: -- (jtf_rs_team_members) that are still not defined in workflow user role

1343: AND wlur.role_orig_system = l_team_orig_system);
1344:
1345:
1346: -- Select all active records from resource team members table
1347: -- (jtf_rs_team_members) that are still not defined in workflow user role
1348: -- table (wf_local_user_roles). This is for 'INDIVIDUAL' resource team
1349: -- members whose category is EMPLOYEE, PARTY, PARTNER or SUPPLIER_CONTACT
1350: -- These records have to be created in workflow user roles table.
1351:

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

1353: SELECT mem.team_resource_id resource_id, mem.team_id, ext.category, ext.resource_name
1354: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1355: ,least (NVL (team.end_date_active, l_fnd_date) ,
1356: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1357: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1358: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1359: AND mem.team_resource_id = ext.resource_id
1360: AND mem.resource_type = 'INDIVIDUAL'
1361: AND mem.team_id = team.team_id

Line 1373: -- (jtf_rs_team_members) that are still not defined in workflow

1369: AND wlur.role_orig_system = l_team_orig_system
1370: AND wlur.user_orig_system = l_hz_orig_system);
1371:
1372: -- Select all active records from resource team members table
1373: -- (jtf_rs_team_members) that are still not defined in workflow
1374: -- user role table (wf_local_user_roles). This is for 'GROUP'
1375: -- resource team members.
1376: -- These records have to be created in workflow user roles table.
1377:

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