36: ptp.end_date,
37: bal.value,
38: to_number(to_char(bal.effective_date,'MM'))
39: from pay_hk_mpf_ri_balances_v bal, 40: per_time_periods ptp 41: where bal.assignment_id = p_assignment_id
42: and bal.balance_name = 'MPF_RI'
43: and bal.payroll_id = ptp.payroll_id
44: and bal.expiry_date between ptp.start_date and ptp.end_date