[Home] [Help]
269: --Bug# 8208686 fixed by ateotia(-)
270: from ozf_request_headers_all_vl a
271: , pv_partner_profiles b
272: , hz_parties c
273: , jtf_rs_resource_extns pt_cont
274: , jtf_rs_resource_extns creator
275: , ozf_lookups lkup
276: -- BUG 4460277 (+)
277: , hz_relationships hz_cont_rel
270: from ozf_request_headers_all_vl a
271: , pv_partner_profiles b
272: , hz_parties c
273: , jtf_rs_resource_extns pt_cont
274: , jtf_rs_resource_extns creator
275: , ozf_lookups lkup
276: -- BUG 4460277 (+)
277: , hz_relationships hz_cont_rel
278: , hz_parties cont
306: ORDER BY CREATION_DATE DESC;
307:
308: cursor lc_last_approver_name (pc_entity_type varchar2, pc_entity_id number) is
309: SELECT res.source_first_name || ' '|| res.source_last_name
310: FROM jtf_rs_resource_extns res, ozf_approval_access oac
311: where res.user_id = oac.approver_id
312: and oac.object_type = pc_entity_type
313: and oac.object_id = pc_entity_id
314: and oac.approval_access_id = ( select max(approval_access_id)
791: usr.user_name
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
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'
836: and usr.user_id = pj.user_id
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
861: and ref.request_header_id = pc_entity_id;
862: