APPS.PV_REFERRAL_GENERAL_PUB dependencies on JTF_TERR_VALUES_ALL

Line 156: jtf_terr_values_all TV

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
160: REF.benefit_id = THR.benefit_id AND