DBA Data[Home] [Help]

APPS.PV_REFERRAL_GENERAL_PUB dependencies on PV_GE_BENEFITS_VL

Line 2022: FROM pv_ge_benefits_vl a, pv_referrals_vl b

2018: WHERE sales_lead_id = pc_entity_id;
2019:
2020: CURSOR c_benefit_type IS
2021: SELECT a.benefit_type_code, b.referral_id, b.partner_id
2022: FROM pv_ge_benefits_vl a, pv_referrals_vl b
2023: WHERE a.benefit_id = b.benefit_id AND
2024: b.referral_id = p_referral_id;
2025:
2026: BEGIN