35: 115.24 08-Jun-02 pabodla Do not select the contingent worker
36: assignment when assignment data is
37: fetched.
38: 115.25 11-Oct-02 vsethi Rates Sequence no enhancements. Modified to cater
39: to new column ord_num on ben_acty_base_rt_f
40: 115.26 30-Dec-2002 mmudigon NOCOPY
41: 115.27 13-feb-2003 kmahendr Added a parameter to call -acty_base_rt.main
42: -----------------------------------------------------------------------------
43: */
67: is
68: select abr2.acty_base_rt_id,
69: abr2.entr_val_at_enrt_flag,
70: abr2.val
71: from ben_acty_base_rt_f abr,
72: ben_acty_base_rt_f abr2
73: where abr.acty_base_rt_id = c_abr_id
74: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
75: and abr2.parnt_chld_cd = 'PARNT'
68: select abr2.acty_base_rt_id,
69: abr2.entr_val_at_enrt_flag,
70: abr2.val
71: from ben_acty_base_rt_f abr,
72: ben_acty_base_rt_f abr2
73: where abr.acty_base_rt_id = c_abr_id
74: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
75: and abr2.parnt_chld_cd = 'PARNT'
76: and c_eff_date
4723: abr.entr_ann_val_flag,
4724: abr.mn_elcn_val,
4725: abr.mx_elcn_val,
4726: abr.incrmt_elcn_val
4727: from ben_acty_base_rt_f abr
4728: where abr.acty_base_rt_id = c_abr_id
4729: and c_eff_date
4730: between abr.effective_start_date
4731: and abr.effective_end_date;