APPS.JTF_RS_CONC_WF_PUB dependencies on JTF_RS_TEAM_MEMBERS

Line 1407: FROM wf_local_user_roles wlur, jtf_rs_team_members mem

1403: -- resource team member records have been deleted (delete_flag Y).
1404:
1405: CURSOR c_wlur_team_mem_del IS
1406: SELECT wlur.user_orig_system, wlur.user_orig_system_id, mem.team_id
1407: FROM wf_local_user_roles wlur, jtf_rs_team_members mem
1408: WHERE NVL (mem.delete_flag,'N') = 'Y'
1409: AND wlur.role_orig_system = l_team_orig_system
1410: AND wlur.role_orig_system_id = mem.team_id
1411: AND wlur.role_name = l_team_orig_system ||':'|| mem.team_id

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

1413: AND NVL(wlur.expiration_date, l_sysdate) >= l_sysdate;
1414:
1415:
1416: -- Select all active records from resource team members table
1417: -- (jtf_rs_team_members) that are still not defined in workflow
1418: -- user role table (wf_local_user_roles). This is for 'INDIVIDUAL'
1419: -- resource team members whose category is OTHER or TBH.
1420: -- These records have to be created in workflow user roles table.
1421:

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 1445: -- (jtf_rs_team_members) that are still not defined in workflow user role

1441: AND wlur.role_orig_system = l_team_orig_system);
1442:
1443:
1444: -- Select all active records from resource team members table
1445: -- (jtf_rs_team_members) that are still not defined in workflow user role
1446: -- table (wf_local_user_roles). This is for 'INDIVIDUAL' resource team
1447: -- members whose category is EMPLOYEE, PARTY, PARTNER or SUPPLIER_CONTACT
1448: -- These records have to be created in workflow user roles table.
1449:

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 1471: -- (jtf_rs_team_members) that are still not defined in workflow

1467: AND wlur.role_orig_system = l_team_orig_system
1468: AND wlur.user_orig_system = l_hz_orig_system);
1469:
1470: -- Select all active records from resource team members table
1471: -- (jtf_rs_team_members) that are still not defined in workflow
1472: -- user role table (wf_local_user_roles). This is for 'GROUP'
1473: -- resource team members.
1474: -- These records have to be created in workflow user roles table.
1475:

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