APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on PV_BENFT_PRODUCTS
Line 1107: FROM pv_ge_benefits_vl a, pv_benft_products b
1103: IS
1104: -- given category, find max compensation from referral tables
1105: CURSOR c_maximum_compensation(p_category_id NUMBER) IS
1106: SELECT b.maximum_compensation 1107: FROM pv_ge_benefits_vl a, pv_benft_products b 1108: WHERE a.benefit_id = b.benefit_id
1109: AND a.benefit_type_code = 'PVREFFRL'
1110: AND a.additional_info_1 = p_offer_id
1111: AND b.product_category_id = p_category_id;