APPS.OZF_REQUEST_STATUS_PVT dependencies on FND_USER

Line 783: fnd_user usr

779: FROM
780: pv_partner_profiles prof,
781: hz_relationships pr2,
782: jtf_rs_resource_extns pj,
783: fnd_user usr
784: WHERE
785: prof.partner_id = pc_partner_id
786: and prof.partner_party_id = pr2.object_id
787: and pr2.subject_table_name = 'HZ_PARTIES'

Line 820: fnd_user usr

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
824: and (usr.end_date > sysdate OR usr.end_date IS NULL)

Line 842: select fnd.user_name

838: from ozf_request_headers_all_b
839: where request_header_id = pc_entity_id;
840:
841: cursor lc_get_pt_cont(pc_entity_id number) is
842: select fnd.user_name
843: from fnd_user fnd
844: , ozf_request_headers_all_b ref
845: , jtf_rs_resource_extns jtf
846: where ref.partner_contact_id = jtf.resource_id

Line 843: from fnd_user fnd

839: where request_header_id = pc_entity_id;
840:
841: cursor lc_get_pt_cont(pc_entity_id number) is
842: select fnd.user_name
843: from fnd_user fnd
844: , ozf_request_headers_all_b ref
845: , jtf_rs_resource_extns jtf
846: where ref.partner_contact_id = jtf.resource_id
847: and jtf.user_id = fnd.user_id

Line 847: and jtf.user_id = fnd.user_id

843: from fnd_user fnd
844: , ozf_request_headers_all_b ref
845: , jtf_rs_resource_extns jtf
846: where ref.partner_contact_id = jtf.resource_id
847: and jtf.user_id = fnd.user_id
848: and ref.request_header_id = pc_entity_id;
849:
850: begin
851: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then