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 2529: from ben_prtt_enrt_rslt_f pen,

2525: cursor c_chk_rt(p_person_id number,
2526: p_element_entry_id number) is
2527: select abr.name rt_name,
2528: prv.rt_strt_dt
2529: from ben_prtt_enrt_rslt_f pen,
2530: ben_prtt_rt_val prv,
2531: ben_acty_base_rt_f abr
2532: where pen.person_id = p_person_id
2533: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 2772: from ben_prtt_enrt_rslt_f pen,

2768: --
2769: cursor c_dup_prv(p_element_entry_value_id number,
2770: p_rt_strt_dt date) is
2771: select abr.name
2772: from ben_prtt_enrt_rslt_f pen,
2773: ben_acty_base_rt_f abr,
2774: ben_prtt_rt_val prv
2775: where prv.acty_base_rt_id <> p_acty_base_rt_id
2776: and prv.element_entry_value_id = p_element_entry_value_id

Line 2790: from ben_prtt_enrt_rslt_f pen1,

2786: --
2787: cursor c_dup_rslt(p_element_entry_id number,
2788: p_rt_strt_dt date) is
2789: select abr1.name
2790: from ben_prtt_enrt_rslt_f pen1,
2791: ben_prtt_enrt_rslt_f pen2,
2792: ben_acty_base_rt_f abr1,
2793: ben_prtt_rt_val prv1
2794: where pen2.prtt_enrt_rslt_id = p_enrt_rslt_id

Line 2791: ben_prtt_enrt_rslt_f pen2,

2787: cursor c_dup_rslt(p_element_entry_id number,
2788: p_rt_strt_dt date) is
2789: select abr1.name
2790: from ben_prtt_enrt_rslt_f pen1,
2791: ben_prtt_enrt_rslt_f pen2,
2792: ben_acty_base_rt_f abr1,
2793: ben_prtt_rt_val prv1
2794: where pen2.prtt_enrt_rslt_id = p_enrt_rslt_id
2795: and pen1.prtt_enrt_rslt_id <> pen2.prtt_enrt_rslt_id

Line 3152: from ben_prtt_enrt_rslt_f pen

3148: l_subpriority number;*/
3149: -- Bug 6716202
3150: cursor c_pen is
3151: select pgm_id,pl_id,oipl_id--,pl_typ_id,ler_id -- 6716202
3152: from ben_prtt_enrt_rslt_f pen
3153: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3154: and pen.prtt_enrt_rslt_stat_cd is null
3155: and rownum = 1 ;
3156: l_pen c_pen%rowtype;

Line 3171: from ben_prtt_enrt_rslt_f pen,

3167: --
3168: cursor c_max_prv is
3169: select
3170: max(prv.rt_strt_dt) max_strt_dt
3171: from ben_prtt_enrt_rslt_f pen,
3172: ben_prtt_rt_val prv
3173: where pen.person_id = p_person_id
3174: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3175: and pen.prtt_enrt_rslt_stat_cd is null

Line 3206: from ben_prtt_enrt_rslt_f pen,

3202: where pev.element_entry_id = c_element_entry_id);
3203:
3204: cursor c_prv is
3205: select pev.element_entry_value_id
3206: from ben_prtt_enrt_rslt_f pen,
3207: ben_prtt_rt_val prv,
3208: pay_element_entry_values_f pev
3209: where pen.person_id = p_person_id
3210: and pen.prtt_enrt_rslt_stat_cd is null

Line 3229: from ben_prtt_enrt_rslt_f pen,

3225: -- non fsa type rates.
3226: --
3227: cursor c_non_fsa_prv is
3228: select pev.element_entry_value_id
3229: from ben_prtt_enrt_rslt_f pen,
3230: ben_prtt_rt_val prv,
3231: pay_element_entry_values_f pev
3232: where pen.person_id = p_person_id
3233: and pen.prtt_enrt_rslt_stat_cd is null