APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on PV_GE_BENEFITS_VL

Line 1204: FROM pv_ge_benefits_vl a, pv_benft_products b

1200: IS
1201: -- given category, find max compensation from referral tables
1202: CURSOR c_maximum_compensation(p_category_id NUMBER) IS
1203: SELECT b.maximum_compensation
1204: FROM pv_ge_benefits_vl a, pv_benft_products b
1205: WHERE a.benefit_id = b.benefit_id
1206: AND a.benefit_type_code = 'PVREFFRL'
1207: AND a.additional_info_1 = p_offer_id
1208: AND b.product_category_id = p_category_id;