APPS.JTF_UM_ROLE_VERIFICATION dependencies on JTF_AUTH_PRINCIPALS_B

Line 149: from jtf_auth_principals_b a, jtf_um_subscriptions_b b

145: END IF;
146:
147: -- verify to see if the auth_principal_name passed as input is assigned to any enrollment as delegation role
148: select count(*) into l_count
149: from jtf_auth_principals_b a, jtf_um_subscriptions_b b
150: where a.principal_name = auth_principal_name
151: and a.JTF_AUTH_PRINCIPAL_ID = b.AUTH_DELEGATION_ROLE_ID
152: and b.effective_end_date is null;
153:

Line 159: from jtf_um_subscriptions_b a, jtf_auth_principals_b b

155: IF( l_count <> 0 ) THEN
156:
157: -- need to find enrollment where the role is used
158: select subscription_key into l_enrollment_key
159: from jtf_um_subscriptions_b a, jtf_auth_principals_b b
160: where b.principal_name = auth_principal_name
161: and b.JTF_AUTH_PRINCIPAL_ID = a.AUTH_DELEGATION_ROLE_ID
162: and a.effective_end_date is null
163: and rownum = 1;