APPS.OZF_REQUEST_STATUS_PVT dependencies on PV_PARTNER_PROFILES

Line 271: , pv_partner_profiles b

267: --Bug# 8208686 fixed by ateotia(+)
268: , a.org_id
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

Line 279: , pv_partner_profiles pvpp

275: , ozf_lookups lkup
276: -- BUG 4460277 (+)
277: , hz_relationships hz_cont_rel
278: , hz_parties cont
279: , pv_partner_profiles pvpp
280: -- BUG 4460277 (-)
281: where a.request_header_id = pc_request_id
282: and a.partner_id = b.partner_id
283: and b.partner_party_id = c.party_id

Line 327: pv_partner_profiles prtnr_profile,

323:
324: cursor lc_vendor_name ( pc_entity_id number) is
325: select vendor.party_name vendor_name
326: from ozf_request_headers_all_vl enrl_req,
327: pv_partner_profiles prtnr_profile,
328: hz_relationships rel_ship,
329: hz_parties vendor
330: where enrl_req.request_header_id = pc_entity_id
331: and enrl_req.partner_id= prtnr_profile.partner_id

Line 793: pv_partner_profiles prof,

789: pc_partner_id number) is
790: SELECT
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