APPS.JTF_UM_ENROLLMENT_CREDENTIALS dependencies on JTF_UM_SUBSCRIPTION_ROLE
Line 156: FROM JTF_UM_SUBSCRIPTION_ROLE
152: AND (SB.EFFECTIVE_END_DATE IS NULL OR SB.EFFECTIVE_END_DATE > SYSDATE)
153: AND SB.EFFECTIVE_START_DATE < SYSDATE;
154:
155: CURSOR SUBSCRIPTION_ROLES IS SELECT PRINCIPAL_NAME 156: FROM JTF_UM_SUBSCRIPTION_ROLE 157: WHERE SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
158: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE)
159: AND EFFECTIVE_START_DATE < SYSDATE;
160: