DBA Data[Home] [Help]

APPS.OZF_APPROVAL_PVT dependencies on JTF_AUTH_PRINCIPALS_B

Line 126: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,

122:
123: CURSOR crs_get_int_super_users(pc_permission varchar2, pc_userid number) is
124: select count(1)
125: from jtf_auth_principal_maps jtfpm,
126: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
127: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
128: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
129: fnd_user usr
130: where PJ.user_name = jtfp1.principal_name

Line 127: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,

123: CURSOR crs_get_int_super_users(pc_permission varchar2, pc_userid number) is
124: select count(1)
125: from jtf_auth_principal_maps jtfpm,
126: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
127: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
128: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
129: fnd_user usr
130: where PJ.user_name = jtfp1.principal_name
131: and pj.category = 'EMPLOYEE'