APPS.CSI_ASSIGN_ROLE_PUB dependencies on JTF_AUTH_PRINCIPALS_B

Line 22: from jtf_auth_principals_b p,

18: and rownum = 1 ) user_type
19: FROM fnd_user us
20: WHERE (us.end_date is null or us.end_date > sysdate)
21: AND EXISTS (select /*+ no_unnest */ null
22: from jtf_auth_principals_b p,
23: jtf_auth_principal_maps pr
24: where p.principal_name = us.user_name
25: and p.is_user_flag = 1
26: and p.jtf_auth_principal_id = pr.jtf_auth_principal_id

Line 28: from jtf_auth_principals_b r

24: where p.principal_name = us.user_name
25: and p.is_user_flag = 1
26: and p.jtf_auth_principal_id = pr.jtf_auth_principal_id
27: and exists (select /*+ no_unnest */ null
28: from jtf_auth_principals_b r
29: where pr.jtf_auth_parent_principal_id = r.jtf_auth_principal_id
30: and r.is_user_flag = 0
31: and r.principal_name like 'IBU%')
32: and not exists (select /*+ no_unnest */ null

Line 33: from jtf_auth_principals_b r

29: where pr.jtf_auth_parent_principal_id = r.jtf_auth_principal_id
30: and r.is_user_flag = 0
31: and r.principal_name like 'IBU%')
32: and not exists (select /*+ no_unnest */ null
33: from jtf_auth_principals_b r
34: where pr.jtf_auth_parent_principal_id = r.jtf_auth_principal_id
35: and r.is_user_flag = 0
36: and r.principal_name like 'CSI%'));
37: BEGIN