[Home] [Help]
115:
116: CURSOR cur_get_pt_details IS
117: SELECT decode(p_ee_element,'Y',nvl(ee_contribution_percent,0),nvl(er_contribution_percent,0))
118: ,decode(p_ee_element,'Y',nvl(ee_contribution_fixed_rate,0),nvl(er_contribution_fixed_rate,0))
119: FROM pqp_pension_types_f
120: WHERE pension_type_id = p_pension_type
121: AND p_effective_start_date BETWEEN effective_start_date
122: AND effective_end_date;
123: