DBA Data[Home] [Help]

APPS.PV_OFFER_PUB dependencies on OZF_OFFERS

Line 184: FROM ozf_offers

180: -- ----------------------------------------------------------
181: -- l_del_modifier_list_rec
182: -- ----------------------------------------------------------
183: FOR x IN (SELECT qp_list_header_id
184: FROM ozf_offers
185: WHERE offer_id = p_offer_id)
186: LOOP
187: l_qp_list_header_id := x.qp_list_header_id;
188: l_del_modifier_list_rec.QP_LIST_HEADER_ID := x.qp_list_header_id;

Line 453: FROM ozf_offers

449: -- ---------------------------------------------------------------
450: -- Retrieve offer_id.
451: -- ---------------------------------------------------------------
452: FOR x IN (SELECT offer_id
453: FROM ozf_offers
454: WHERE qp_list_header_id = l_qp_list_header_id)
455: LOOP
456: x_offer_id := x.offer_id;
457: