APPS.BEN_ELEMENT_ENTRY dependencies on BEN_PRTT_ENRT_RSLT_F

Line 63: from ben_prtt_enrt_rslt_f pen,

59: )
60: is
61: select distinct
62: yp.start_date,yp.end_date
63: from ben_prtt_enrt_rslt_f pen,
64: ben_popl_yr_perd pyp,
65: ben_yr_perd yp
66: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
67: and pen.prtt_enrt_rslt_stat_cd is null

Line 104: from ben_prtt_enrt_rslt_f pen,

100: pen.person_id,
101: pen.effective_start_date,
102: pen.effective_end_date,
103: pen.uom
104: from ben_prtt_enrt_rslt_f pen,
105: ben_oipl_f opt
106: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
107: and pen.prtt_enrt_rslt_stat_cd is null
108: and opt.oipl_id(+)=pen.oipl_id

Line 2563: from ben_prtt_enrt_rslt_f pen,

2559: cursor c_chk_rt(p_person_id number,
2560: p_element_entry_id number) is
2561: select abr.name rt_name,
2562: prv.rt_strt_dt
2563: from ben_prtt_enrt_rslt_f pen,
2564: ben_prtt_rt_val prv,
2565: ben_acty_base_rt_f abr
2566: where pen.person_id = p_person_id
2567: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 2903: from ben_prtt_enrt_rslt_f pen,

2899: --
2900: cursor c_dup_prv(p_element_entry_value_id number,
2901: p_rt_strt_dt date) is
2902: select abr.name
2903: from ben_prtt_enrt_rslt_f pen,
2904: ben_acty_base_rt_f abr,
2905: ben_prtt_rt_val prv
2906: where prv.acty_base_rt_id <> p_acty_base_rt_id
2907: and prv.element_entry_value_id = p_element_entry_value_id

Line 2921: from ben_prtt_enrt_rslt_f pen1,

2917: --
2918: cursor c_dup_rslt(p_element_entry_id number,
2919: p_rt_strt_dt date) is
2920: select abr1.name
2921: from ben_prtt_enrt_rslt_f pen1,
2922: ben_prtt_enrt_rslt_f pen2,
2923: ben_acty_base_rt_f abr1,
2924: ben_prtt_rt_val prv1
2925: where pen2.prtt_enrt_rslt_id = p_enrt_rslt_id

Line 2922: ben_prtt_enrt_rslt_f pen2,

2918: cursor c_dup_rslt(p_element_entry_id number,
2919: p_rt_strt_dt date) is
2920: select abr1.name
2921: from ben_prtt_enrt_rslt_f pen1,
2922: ben_prtt_enrt_rslt_f pen2,
2923: ben_acty_base_rt_f abr1,
2924: ben_prtt_rt_val prv1
2925: where pen2.prtt_enrt_rslt_id = p_enrt_rslt_id
2926: and pen1.prtt_enrt_rslt_id <> pen2.prtt_enrt_rslt_id

Line 3358: from ben_prtt_enrt_rslt_f pen

3354: l_subpriority number;*/
3355: -- Bug 6716202
3356: cursor c_pen is
3357: select pgm_id,pl_id,oipl_id--,pl_typ_id,ler_id -- 6716202
3358: from ben_prtt_enrt_rslt_f pen
3359: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3360: and pen.prtt_enrt_rslt_stat_cd is null
3361: and rownum = 1 ;
3362: l_pen c_pen%rowtype;

Line 3377: from ben_prtt_enrt_rslt_f pen,

3373: --
3374: cursor c_max_prv is
3375: select
3376: max(prv.rt_strt_dt) max_strt_dt
3377: from ben_prtt_enrt_rslt_f pen,
3378: ben_prtt_rt_val prv
3379: where pen.person_id = p_person_id
3380: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3381: and pen.prtt_enrt_rslt_stat_cd is null

Line 3432: from ben_prtt_enrt_rslt_f pen,

3428: -- end 13709907
3429: --
3430: cursor c_prv is
3431: select pev.element_entry_value_id
3432: from ben_prtt_enrt_rslt_f pen,
3433: ben_prtt_rt_val prv,
3434: pay_element_entry_values_f pev
3435: where pen.person_id = p_person_id
3436: and pen.prtt_enrt_rslt_stat_cd is null

Line 3455: from ben_prtt_enrt_rslt_f pen,

3451: -- non fsa type rates.
3452: --
3453: cursor c_non_fsa_prv is
3454: select pev.element_entry_value_id
3455: from ben_prtt_enrt_rslt_f pen,
3456: ben_prtt_rt_val prv,
3457: pay_element_entry_values_f pev
3458: where pen.person_id = p_person_id
3459: and pen.prtt_enrt_rslt_stat_cd is null

Line 8913: from ben_prtt_enrt_rslt_f pen

8909: l_current_pil c_current_pil%rowtype;
8910:
8911: cursor c_check_current_pen(p_pil_id number) is
8912: select *
8913: from ben_prtt_enrt_rslt_f pen
8914: where pen.prtt_enrt_rslt_id = p_enrt_rslt_id
8915: and pen.business_group_id = p_business_group_id
8916: and pen.person_id = p_person_id
8917: and pen.prtt_enrt_rslt_stat_cd is null