DBA Data[Home] [Help]

APPS.OZF_REQUEST_STATUS_PVT dependencies on OZF_REQUEST_HEADERS_ALL_VL

Line 270: from ozf_request_headers_all_vl a

266: , NVL(a.offer_id,-1)
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

Line 326: from ozf_request_headers_all_vl enrl_req,

322: where media_id = pc_media_id;
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