APPS.JTF_UM_ROLE_VERIFICATION dependencies on JTF_UM_SUBSCRIPTIONS_B

Line 26: update jtf_um_subscriptions_b

22: */
23: procedure UPDATE_AUTH_PRINCIPAL_ID(old_auth_principal_id in number,
24: new_auth_principal_id in number ) IS
25: BEGIN
26: update jtf_um_subscriptions_b
27: set AUTH_DELEGATION_ROLE_ID = new_auth_principal_id
28: where AUTH_DELEGATION_ROLE_ID = old_auth_principal_id;
29: END;
30:

Line 118: from jtf_um_subscription_role a, jtf_um_subscriptions_b b

114: END IF;
115:
116: -- verify to see if the auth_principal_name passed as input is assigned to any enrollment
117: select count(*) into l_count
118: from jtf_um_subscription_role a, jtf_um_subscriptions_b b
119: where a.principal_name = auth_principal_name
120: and a.subscription_id = b.subscription_id
121: and a.effective_end_date is null
122: and b.effective_end_date is null;

Line 131: from jtf_um_subscriptions_b a, jtf_um_subscription_role b

127: -- x_if_referred_flag := 'Y';
128:
129: -- need to find usertype where the role is used
130: select subscription_key into l_enrollment_key
131: from jtf_um_subscriptions_b a, jtf_um_subscription_role b
132: where b.principal_name = auth_principal_name
133: and a.subscription_id = b.subscription_id
134: and a.effective_end_date is null
135: and b.effective_end_date is null

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;