APPS.JTF_RS_CONC_WF_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 1074: FROM wf_local_user_roles wlur, jtf_rs_group_members mem

1070: -- resource group member records have been deleted (delete_flag Y).
1071:
1072: CURSOR c_wlur_grp_mem_del IS
1073: SELECT wlur.user_orig_system, wlur.user_orig_system_id, mem.group_id
1074: FROM wf_local_user_roles wlur, jtf_rs_group_members mem
1075: WHERE NVL (mem.delete_flag,'N') = 'Y'
1076: AND wlur.role_orig_system = l_grp_orig_system
1077: AND wlur.role_orig_system_id = mem.group_id
1078: AND wlur.role_name = l_grp_orig_system ||':'|| mem.group_id

Line 1083: -- (jtf_rs_group_members) that are still not defined in workflow

1079: AND wlur.user_orig_system <> l_grp_orig_system
1080: AND NVL(wlur.expiration_date, l_sysdate) >= l_sysdate;
1081:
1082: -- Cursor to select all active records from resource group members table
1083: -- (jtf_rs_group_members) that are still not defined in workflow
1084: -- user role table (wf_local_user_roles). This is for category OTHER and TBH.
1085: -- These records have to be created in workflow user roles table.
1086:
1087: CURSOR c_grp_mem_wf_crt IS

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

1106: AND wlur.user_orig_system = l_ind_orig_system
1107: AND wlur.role_orig_system = l_grp_orig_system);
1108:
1109: -- Select all active records from resource group members table
1110: -- (jtf_rs_group_members) that are still not defined in workflow
1111: -- user role table (wf_local_user_roles). This is for category
1112: -- EMPLOYEE, PARTY, PARTNER and SUPPLIER_CONTACT
1113: -- These records have to be created in workflow user roles table.
1114:

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'