DBA Data[Home] [Help]

APPS.BEN_SSPNDD_ENROLLMENT dependencies on PAY_ELEMENT_ENTRIES_F

Line 2954: pay_element_entries_f pee

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

Line 3705: pay_element_entries_f pee

3701: --
3702: cursor c_ee (p_element_entry_value_id number,p_rt_strt_dt date) is
3703: select pev.effective_end_date
3704: from pay_element_entry_values_f pev,
3705: pay_element_entries_f pee
3706: where pev.element_entry_value_id = p_element_entry_value_id
3707: and p_rt_strt_dt between
3708: pev.effective_start_date and pev.effective_end_date
3709: and pee.element_entry_id = pev.element_entry_id