APPS.PV_REFERRAL_GENERAL_PUB dependencies on JTF_TERR_ALL

Line 154: jtf_terr_all TR,

150: CURSOR c_expired IS
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