DBA Data[Home] [Help]

APPS.OZF_REQUEST_STATUS_PVT dependencies on JTF_AUTH_PERMISSIONS_B

Line 801: jtf_auth_permissions_b jtfperm

797: and (usr.end_date > sysdate OR usr.end_date IS NULL)
798: and exists(select 1 from jtf_auth_principal_maps jtfpm,
799: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
800: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
801: jtf_auth_permissions_b jtfperm
802: where PJ.user_name = jtfp1.principal_name
803: and jtfp1.is_user_flag=1
804: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
805: and jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id

Line 819: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,

815: select usr.user_name
816: from jtf_auth_principal_maps jtfpm,
817: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
818: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
819: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
820: fnd_user usr
821: where PJ.user_name = jtfp1.principal_name
822: and pj.category = 'EMPLOYEE'
823: and usr.user_id = pj.user_id