APPS.OZF_REQUEST_STATUS_PVT dependencies on JTF_AUTH_PRINCIPALS_B

Line 812: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,

808: and pj.category = 'PARTY'
809: and usr.user_id = pj.user_id
810: and (usr.end_date > sysdate OR usr.end_date IS NULL)
811: and exists(select 1 from jtf_auth_principal_maps jtfpm,
812: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
813: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
814: jtf_auth_permissions_b jtfperm
815: where PJ.user_name = jtfp1.principal_name
816: and jtfp1.is_user_flag=1

Line 813: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,

809: and usr.user_id = pj.user_id
810: and (usr.end_date > sysdate OR usr.end_date IS NULL)
811: and exists(select 1 from jtf_auth_principal_maps jtfpm,
812: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
813: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
814: jtf_auth_permissions_b jtfperm
815: where PJ.user_name = jtfp1.principal_name
816: and jtfp1.is_user_flag=1
817: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id

Line 830: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,

826:
827: cursor lc_get_int_super_users(pc_permission varchar2) is
828: select unique usr.user_name
829: from jtf_auth_principal_maps jtfpm,
830: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
831: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
832: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
833: fnd_user usr
834: where PJ.user_name = jtfp1.principal_name

Line 831: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,

827: cursor lc_get_int_super_users(pc_permission varchar2) is
828: select unique usr.user_name
829: from jtf_auth_principal_maps jtfpm,
830: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
831: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
832: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
833: fnd_user usr
834: where PJ.user_name = jtfp1.principal_name
835: and pj.category = 'EMPLOYEE'