[Home] [Help]
261: , NVL(a.offer_id,-1)
262: from ozf_request_headers_all_vl a
263: , pv_partner_profiles b
264: , hz_parties c
265: , jtf_rs_resource_extns pt_cont
266: , jtf_rs_resource_extns creator
267: , ozf_lookups lkup
268: -- BUG 4460277 (+)
269: , hz_relationships hz_cont_rel
262: from ozf_request_headers_all_vl a
263: , pv_partner_profiles b
264: , hz_parties c
265: , jtf_rs_resource_extns pt_cont
266: , jtf_rs_resource_extns creator
267: , ozf_lookups lkup
268: -- BUG 4460277 (+)
269: , hz_relationships hz_cont_rel
270: , hz_parties cont
298: ORDER BY CREATION_DATE DESC;
299:
300: cursor lc_last_approver_name (pc_entity_type varchar2, pc_entity_id number) is
301: SELECT res.source_first_name || ' '|| res.source_last_name
302: FROM jtf_rs_resource_extns res, ozf_approval_access oac
303: where res.user_id = oac.approver_id
304: and oac.object_type = pc_entity_type
305: and oac.object_id = pc_entity_id
306: and oac.approval_access_id = ( select max(approval_access_id)
778: usr.user_name
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
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
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
848: and ref.request_header_id = pc_entity_id;
849: