[Home] [Help]
96: select name,
97: rcrrg_cd,
98: ele_rqd_flag,
99: element_type_id
100: from ben_acty_base_rt_f
101: where business_group_id = p_business_group_id
102: and p_acty_base_rt_id = acty_base_rt_id
103: and p_rt_strt_dt between effective_start_date
104: and effective_end_date ;
307: --Bug 4141719: Retrieve the rate name which will be used to show
308: --in the note 93120(if the note is applicable)
309: cursor c_abr is
310: select name
311: from ben_acty_base_rt_f
312: where business_group_id = p_business_group_id
313: and p_acty_base_rt_id = acty_base_rt_id
314: and p_rt_strt_dt between effective_start_date
315: and effective_end_date ;