DBA Data[Home] [Help]

APPS.BEN_SSPNDD_ENROLLMENT dependencies on BEN_ACTY_BASE_RT_F

Line 3098: ben_acty_base_rt_f abr,

3094: ,prv.element_entry_value_id
3095: ,pev.effective_end_date
3096: ,pee.element_link_id
3097: from ben_prtt_rt_val prv,
3098: ben_acty_base_rt_f abr,
3099: pay_element_entry_values_f pev,
3100: pay_element_entries_f pee
3101: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3102: and prv.rt_end_dt=hr_api.g_eot

Line 3826: ben_acty_base_rt_f abr

3822: select prv.*
3823: ,abr.input_value_id
3824: ,abr.element_type_id
3825: from ben_prtt_rt_val prv,
3826: ben_acty_base_rt_f abr
3827: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3828: and prv.per_in_ler_id = l_per_in_ler_id
3829: and prv.rt_strt_dt <= prv.rt_end_dt
3830: -- and prv.rt_end_dt=hr_api.g_eot