DBA Data[Home] [Help]

APPS.BEN_SSPNDD_ENROLLMENT dependencies on BEN_ACTY_BASE_RT_F

Line 2952: ben_acty_base_rt_f abr,

2948: ,prv.element_entry_value_id
2949: ,pev.effective_end_date
2950: ,pee.element_link_id
2951: from ben_prtt_rt_val prv,
2952: ben_acty_base_rt_f abr,
2953: pay_element_entry_values_f pev,
2954: pay_element_entries_f pee
2955: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
2956: and prv.rt_end_dt=hr_api.g_eot

Line 3657: ben_acty_base_rt_f abr

3653: select prv.*
3654: ,abr.input_value_id
3655: ,abr.element_type_id
3656: from ben_prtt_rt_val prv,
3657: ben_acty_base_rt_f abr
3658: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3659: and prv.per_in_ler_id = l_per_in_ler_id
3660: and prv.rt_strt_dt <= prv.rt_end_dt
3661: -- and prv.rt_end_dt=hr_api.g_eot