APPS.OZF_REQUEST_STATUS_PVT dependencies on PV_PARTNER_PROFILES

Line 263: , pv_partner_profiles b

259: , a.activity_media_id
260: , a.request_type_code
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

Line 271: , pv_partner_profiles pvpp

267: , ozf_lookups lkup
268: -- BUG 4460277 (+)
269: , hz_relationships hz_cont_rel
270: , hz_parties cont
271: , pv_partner_profiles pvpp
272: -- BUG 4460277 (-)
273: where a.request_header_id = pc_request_id
274: and a.partner_id = b.partner_id
275: and b.partner_party_id = c.party_id

Line 319: pv_partner_profiles prtnr_profile,

315:
316: cursor lc_vendor_name ( pc_entity_id number) is
317: select vendor.party_name vendor_name
318: from ozf_request_headers_all_vl enrl_req,
319: pv_partner_profiles prtnr_profile,
320: hz_relationships rel_ship,
321: hz_parties vendor
322: where enrl_req.request_header_id = pc_entity_id
323: and enrl_req.partner_id= prtnr_profile.partner_id

Line 780: pv_partner_profiles prof,

776: pc_partner_id number) is
777: SELECT
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