APPS.JTF_UM_ROLE_VERIFICATION dependencies on JTF_UM_SUBSCRIPTION_ROLE

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