DBA Data[Home] [Help]

APPS.PV_ASSIGN_UTIL_PVT dependencies on JTF_AUTH_PERMISSIONS_B

Line 1113: jtf_auth_permissions_b jtfperm

1109: and (usr.end_date > sysdate OR usr.end_date IS NULL)
1110: and exists(select 1 from jtf_auth_principal_maps jtfpm,
1111: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
1112: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
1113: jtf_auth_permissions_b jtfperm
1114: where usr.user_name = jtfp1.principal_name
1115: and jtfp1.is_user_flag=1
1116: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
1117: and jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id