APPS.JTF_UM_WF_DELEGATION_PVT dependencies on JTF_UM_SUBSCRIPTION_ROLE

Line 37: CURSOR FIND_SUB_ROLES IS SELECT PRINCIPAL_NAME FROM JTF_UM_SUBSCRIPTION_ROLE

33: x_has_enrollment out NOCOPY number
34: ) IS
35:
36: l_procedure_name CONSTANT varchar2(30) := 'has_admin_enrollment';
37: CURSOR FIND_SUB_ROLES IS SELECT PRINCIPAL_NAME FROM JTF_UM_SUBSCRIPTION_ROLE
38: WHERE SUBSCRIPTION_ID = p_subscription_id
39: AND NVL(EFFECTIVE_END_DATE , SYSDATE+1) > SYSDATE;
40:
41: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;