DBA Data[Home] [Help]

APPS.BEN_SSPNDD_ENROLLMENT dependencies on PAY_ELEMENT_ENTRIES_F

Line 3100: pay_element_entries_f pee

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
3103: and prv.business_group_id = p_business_group_id
3104: and prv.prtt_rt_val_stat_cd is null

Line 3874: pay_element_entries_f pee

3870: --
3871: cursor c_ee (p_element_entry_value_id number,p_rt_strt_dt date) is
3872: select pev.effective_end_date
3873: from pay_element_entry_values_f pev,
3874: pay_element_entries_f pee
3875: where pev.element_entry_value_id = p_element_entry_value_id
3876: and p_rt_strt_dt between
3877: pev.effective_start_date and pev.effective_end_date
3878: and pee.element_entry_id = pev.element_entry_id