APPS.OZF_REQUEST_STATUS_PVT dependencies on FND_USER

Line 796: fnd_user usr

792: FROM
793: pv_partner_profiles prof,
794: hz_relationships pr2,
795: jtf_rs_resource_extns pj,
796: fnd_user usr
797: WHERE
798: prof.partner_id = pc_partner_id
799: and prof.partner_party_id = pr2.object_id
800: and pr2.subject_table_name = 'HZ_PARTIES'

Line 833: fnd_user usr

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'
836: and usr.user_id = pj.user_id
837: and (usr.end_date > sysdate OR usr.end_date IS NULL)

Line 855: select fnd.user_name

851: from ozf_request_headers_all_b
852: where request_header_id = pc_entity_id;
853:
854: cursor lc_get_pt_cont(pc_entity_id number) is
855: select fnd.user_name
856: from fnd_user fnd
857: , ozf_request_headers_all_b ref
858: , jtf_rs_resource_extns jtf
859: where ref.partner_contact_id = jtf.resource_id

Line 856: from fnd_user fnd

852: where request_header_id = pc_entity_id;
853:
854: cursor lc_get_pt_cont(pc_entity_id number) is
855: select fnd.user_name
856: from fnd_user fnd
857: , ozf_request_headers_all_b ref
858: , jtf_rs_resource_extns jtf
859: where ref.partner_contact_id = jtf.resource_id
860: and jtf.user_id = fnd.user_id

Line 860: and jtf.user_id = fnd.user_id

856: from fnd_user fnd
857: , ozf_request_headers_all_b ref
858: , jtf_rs_resource_extns jtf
859: where ref.partner_contact_id = jtf.resource_id
860: and jtf.user_id = fnd.user_id
861: and ref.request_header_id = pc_entity_id;
862:
863: begin
864: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then