APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPE_ROLE

Line 538: FROM JTF_UM_USERTYPE_ROLE

534: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)
535: AND UT.EFFECTIVE_START_DATE < SYSDATE;
536:
537: CURSOR USERTYPE_ROLES IS SELECT PRINCIPAL_NAME
538: FROM JTF_UM_USERTYPE_ROLE
539: WHERE USERTYPE_ID = X_USERTYPE_ID
540: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE)
541: AND EFFECTIVE_START_DATE < SYSDATE;
542:

Line 987: jtf_um_usertype_role where usertype_id = l_usertype_id

983: l_usertype_key VARCHAR2(30);
984: l_principal_name VARCHAR2(255);
985:
986: cursor find_default_role is select principal_name from
987: jtf_um_usertype_role where usertype_id = l_usertype_id
988: and (effective_end_date is null or effective_end_date > sysdate) ;
989:
990: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
991: where usertype_key = l_usertype_key