APPS.PV_REFERRAL_GENERAL_PUB dependencies on PV_PARTNER_PROFILES

Line 980: pv_partner_profiles PROF,

976: HZP.party_name partner_name,
977: REF.CUSTOMER_NAME customer_name
978: FROM pv_referrals_b REF,
979: pv_ge_benefits_b BEN,
980: pv_partner_profiles PROF,
981: hz_parties HZP
982: WHERE REF.referral_id = p_referral_id AND
983: REF.benefit_id = BEN.benefit_id AND
984: REF.partner_id = PROF.partner_id AND