DBA Data[Home] [Help]

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: