APPS.PV_REFERRAL_COMP_PUB dependencies on OZF_OFFERS

Line 560: ozf_offers OFFER

556: oe_order_headers_all HEADER,
557: oe_order_lines_all LINE,
558: mtl_item_categories MIC,
559: eni_prod_denorm_hrchy_v DENORM,
560: ozf_offers OFFER
561: WHERE REF.referral_id = pc_referral_id AND
562: BENFT.benefit_id = REF.benefit_id AND
563: REF.referral_status IN ('APPROVED', 'MANUAL_EXTEND', 'CLOSED_OPPTY_WON') AND
564: REF.referral_id = PROD.referral_id AND

Line 698: FOR z IN (SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = x.offer_id) LOOP

694: l_claim_rec.source_object_number := SUBSTR(x.referral_code, 1, 30);
695: l_claim_rec.cust_account_id := x.partner_cust_account_id;
696: l_claim_rec.pay_to_cust_account_id := x.partner_cust_account_id;
697:
698: FOR z IN (SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = x.offer_id) LOOP
699: l_promotion_activity_rec.offer_id := z.qp_list_header_id;
700: END LOOP;
701:
702: l_promotion_activity_rec.reference_type := 'LEAD_REFERRAL';