APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPE_ROLE

Line 587: FROM JTF_UM_USERTYPE_ROLE

583: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)
584: AND UT.EFFECTIVE_START_DATE < SYSDATE;
585:
586: CURSOR USERTYPE_ROLES IS SELECT PRINCIPAL_NAME
587: FROM JTF_UM_USERTYPE_ROLE
588: WHERE USERTYPE_ID = X_USERTYPE_ID
589: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE)
590: AND EFFECTIVE_START_DATE < SYSDATE;
591:

Line 1042: jtf_um_usertype_role where usertype_id = l_usertype_id

1038: l_usertype_key VARCHAR2(30);
1039: l_principal_name VARCHAR2(255);
1040:
1041: cursor find_default_role is select principal_name from
1042: jtf_um_usertype_role where usertype_id = l_usertype_id
1043: and (effective_end_date is null or effective_end_date > sysdate) ;
1044:
1045: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
1046: where usertype_key = l_usertype_key