308: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)
309: AND UT.EFFECTIVE_START_DATE < SYSDATE;
310:
311: CURSOR USERTYPE_ROLES(usertype_id NUMBER) IS SELECT PRINCIPAL_NAME
312: FROM JTF_UM_USERTYPE_ROLE
313: WHERE USERTYPE_ID = usertype_id
314: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE)
315: AND EFFECTIVE_START_DATE < SYSDATE;
316:
1424: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)
1425: AND UT.EFFECTIVE_START_DATE < SYSDATE;
1426:
1427: CURSOR USERTYPE_ROLES(usertype_id NUMBER) IS SELECT PRINCIPAL_NAME
1428: FROM JTF_UM_USERTYPE_ROLE
1429: WHERE USERTYPE_ID = usertype_id
1430: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE)
1431: AND EFFECTIVE_START_DATE < SYSDATE;
1432:
1492: and (jtsr.effective_end_date is null or jtsr.effective_end_date > sysdate));
1493:
1494: cursor role_list(l_usertype_id VARCHAR2) is
1495: select principal_name
1496: from jtf_um_usertype_role jtur
1497: where jtur.usertype_id = l_usertype_id
1498: and (jtur.effective_end_date is null or jtur.effective_end_date > sysdate)
1499: union
1500: select jtsr.principal_name
2030: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)
2031: AND UT.EFFECTIVE_START_DATE < SYSDATE;
2032:
2033: CURSOR USERTYPE_ROLES(usertype_id NUMBER) IS SELECT PRINCIPAL_NAME
2034: FROM JTF_UM_USERTYPE_ROLE
2035: WHERE USERTYPE_ID = usertype_id
2036: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE)
2037: AND EFFECTIVE_START_DATE < SYSDATE;
2038:
2100: and (jtsr.effective_end_date is null or jtsr.effective_end_date > sysdate));
2101:
2102: cursor role_list(l_usertype_id VARCHAR2) is
2103: select principal_name
2104: from jtf_um_usertype_role jtur
2105: where jtur.usertype_id = l_usertype_id
2106: and (jtur.effective_end_date is null or jtur.effective_end_date > sysdate)
2107: union
2108: select jtsr.principal_name