14: CURSOR c_ee_contrib IS
15: SELECT prv.cmcd_rt_val ||' '||
16: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',
17: prv.cmcd_ref_perd_cd)
18: FROM ben_prtt_rt_val prv
19: WHERE prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
20: AND prv.per_in_ler_id = p_per_in_ler_id
21: AND prv.acty_typ_cd = p_acty_typ_cd
22: AND prv.prtt_rt_val_stat_cd IS NULL
25: CURSOR c_er_contrib IS
26: SELECT prv.cmcd_rt_val ||' '||
27: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',
28: prv.cmcd_ref_perd_cd)
29: FROM ben_prtt_rt_val prv
30: WHERE prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
31: AND prv.per_in_ler_id = p_per_in_ler_id
32: AND prv.acty_typ_cd = p_acty_typ_cd
33: AND prv.prtt_rt_val_stat_cd IS NULL;