APPS.PV_REFERRAL_GENERAL_PUB dependencies on JTF_TERR_QUAL_ALL

Line 155: jtf_terr_qual_all TQ,

151: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
152: FROM pv_referrals_vl REF,
153: pv_benft_thresholds THR,
154: jtf_terr_all TR,
155: jtf_terr_qual_all TQ,
156: jtf_terr_values_all TV
157: WHERE REF.referral_status = 'APPROVED' AND
158: REF.status_change_date + THR.expiration < SYSDATE AND
159: REF.order_id IS NULL AND