APPS.PV_REFERRAL_COMP_PUB dependencies on PV_REFERRALS_VL

Line 481: FROM pv_referrals_vl REF,

477: REF.org_id,
478: REF.partner_id,
479: BENFT.additional_info_1 offer_id,
480: BENFT.benefit_id
481: FROM pv_referrals_vl REF,
482: pv_ge_benefits_b BENFT
483: WHERE BENFT.benefit_id = REF.benefit_id AND
484: REF.order_id > 0 AND
485: REF.claim_id IS NULL;