APPS.JTF_UM_ROLE_VERIFICATION dependencies on JTF_UM_USERTYPES_B

Line 88: from jtf_um_usertype_role a, jtf_um_usertypes_b b

84: -- business logic starts
85:
86: -- verify to see if the auth_principal_name passed as input is assigned to any usertype
87: select count(*) into l_count
88: from jtf_um_usertype_role a, jtf_um_usertypes_b b
89: where a.principal_name = auth_principal_name
90: and a.usertype_id = b.usertype_id
91: and a.effective_end_date is null
92: and b.effective_end_date is null;

Line 100: from jtf_um_usertypes_b a, jtf_um_usertype_role b

96: -- x_if_referred_flag := 'Y';
97:
98: -- need to find usertype where the role is used
99: select usertype_key into l_usertype_key
100: from jtf_um_usertypes_b a, jtf_um_usertype_role b
101: where b.principal_name = auth_principal_name
102: and a.usertype_id = b.usertype_id
103: and a.effective_end_date is null
104: and b.effective_end_date is null