APPS.JTF_UM_UTIL_PVT dependencies on JTF_AUTH_PRINCIPAL_MAPS

Line 1568: CURSOR CHECK_ROLE_ASSIGNMENT IS SELECT JTF_AUTH_PRINCIPAL_MAPPING_ID FROM JTF_AUTH_PRINCIPAL_MAPS

1564: l_procedure_name CONSTANT varchar2(30) := 'check_role';
1565: CURSOR VALIDATE_ROLE IS SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B
1566: WHERE JTF_AUTH_PRINCIPAL_ID = p_auth_principal_id AND IS_USER_FLAG = 0;
1567:
1568: CURSOR CHECK_ROLE_ASSIGNMENT IS SELECT JTF_AUTH_PRINCIPAL_MAPPING_ID FROM JTF_AUTH_PRINCIPAL_MAPS
1569: WHERE JTF_AUTH_PARENT_PRINCIPAL_ID = p_auth_principal_id
1570: AND JTF_AUTH_PRINCIPAL_ID IN
1571: (SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B ROLE, FND_USER FU
1572: WHERE FU.USER_NAME = ROLE.PRINCIPAL_NAME AND FU.USER_ID = p_user_id);