DBA Data[Home] [Help]

APPS.CSI_ASSIGN_ROLE_PUB dependencies on JTF_AUTH_PRINCIPAL_MAPS

Line 23: jtf_auth_principal_maps pr

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
27: and exists (select /*+ no_unnest */ null