DBA Data[Home] [Help]

APPS.BEN_PRTT_RT_VAL_API dependencies on BEN_ACTY_BASE_RT_F

Line 100: from ben_acty_base_rt_f

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 ;

Line 311: from ben_acty_base_rt_f

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 ;