APPS.BEN_ELEMENT_ENTRY dependencies on BEN_ACTY_BASE_RT_F

Line 17: g_acty_base_rt_name ben_acty_base_rt_f.name%type := null;

13: --
14: g_hash_jump number := ben_hash_utility.get_hash_jump;
15: --
16: g_msg_displayed number :=0; --2530582
17: g_acty_base_rt_name ben_acty_base_rt_f.name%type := null;
18: --
19:
20: type g_get_link_row is record
21: (assignment_id number

Line 1149: from ben_acty_base_rt_f abr

1145: ,c_effective_date in date
1146: )
1147: is
1148: select abr.asmt_to_use_cd
1149: from ben_acty_base_rt_f abr
1150: where abr.acty_base_rt_id = c_acty_base_rt_id
1151: and c_effective_date between
1152: abr.effective_start_date and abr.effective_end_date;
1153: --

Line 1524: from ben_acty_base_rt_f abr

1520: --
1521: cursor c1 is
1522: select nvl(abr.ele_entry_val_cd,'PP') ele_entry_val_cd,
1523: abr.name
1524: from ben_acty_base_rt_f abr
1525: where abr.acty_base_rt_id = p_acty_base_rt_id
1526: and p_rate_date between abr.effective_start_date
1527: and abr.effective_end_date;
1528: --

Line 1530: l_name ben_acty_base_rt_f.name%TYPE ;

1526: and p_rate_date between abr.effective_start_date
1527: and abr.effective_end_date;
1528: --
1529: l_ele_entry_val_cd varchar2(30);
1530: l_name ben_acty_base_rt_f.name%TYPE ;
1531: --
1532: begin
1533: g_debug := hr_utility.debug_enabled;
1534: if g_debug then

Line 2565: ben_acty_base_rt_f abr

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
2568: and prv.prtt_rt_val_stat_cd is null
2569: and pen.prtt_enrt_rslt_stat_cd is null

Line 2811: from ben_acty_base_rt_f abr

2807: abr.rcrrg_cd,
2808: abr.name
2809: -- bug 6441505
2810: ,abr.element_det_rl
2811: from ben_acty_base_rt_f abr
2812: where abr.acty_base_rt_id=c_acty_base_rt_id
2813: and c_effective_date between abr.effective_start_date
2814: and abr.effective_end_date;
2815: --

Line 2904: ben_acty_base_rt_f abr,

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
2908: and prv.prtt_rt_val_stat_cd is null

Line 2923: ben_acty_base_rt_f abr1,

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
2927: and pen1.person_id = pen2.person_id

Line 3064: from ben_acty_base_rt_f abr,

3060: )
3061: is
3062: select abr2.rt_mlt_cd,
3063: abr2.entr_ann_val_flag
3064: from ben_acty_base_rt_f abr,
3065: ben_acty_base_rt_f abr2
3066: where abr.acty_base_rt_id = c_acty_base_rt_id
3067: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
3068: and abr2.parnt_chld_cd = 'PARNT'

Line 3065: ben_acty_base_rt_f abr2

3061: is
3062: select abr2.rt_mlt_cd,
3063: abr2.entr_ann_val_flag
3064: from ben_acty_base_rt_f abr,
3065: ben_acty_base_rt_f abr2
3066: where abr.acty_base_rt_id = c_acty_base_rt_id
3067: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
3068: and abr2.parnt_chld_cd = 'PARNT'
3069: and c_effective_date

Line 3135: ben_acty_base_rt_f abr

3131: is
3132: SELECT ecr.enrt_rt_id
3133: FROM ben_enrt_rt ecr,
3134: ben_prtt_rt_val prv,
3135: ben_acty_base_rt_f abr
3136: WHERE prv.prtt_rt_val_id = ecr.prtt_rt_val_id
3137: AND prv.prtt_rt_val_stat_cd is NULL
3138: AND abr.acty_base_rt_id = prv.acty_base_rt_id
3139: AND ecr.acty_base_rt_id = prv.acty_base_rt_id

Line 3486: ben_acty_base_rt_f abr

3482: pev.input_value_id,
3483: abr.ele_entry_val_cd -- Bug 5575402
3484: from pay_element_entries_f pee,
3485: pay_element_entry_values_f pev,
3486: ben_acty_base_rt_f abr
3487: where pev.element_entry_value_id = l_ee_id
3488: and pee.element_entry_id = pev.element_entry_id
3489: and pev.effective_start_date between pee.effective_start_date
3490: and pee.effective_end_date

Line 7226: from ben_acty_base_rt_f abr

7222: abr.input_va_calc_rl,
7223: abr.element_type_id,
7224: abr.input_value_id,
7225: abr.prtl_mo_det_mthd_cd
7226: from ben_acty_base_rt_f abr
7227: where abr.acty_base_rt_id=p_acty_base_rt_id
7228: and p_effective_date between
7229: abr.effective_start_date and abr.effective_end_date;
7230: --

Line 7349: ,ben_acty_base_rt_f abr

7345: Cursor c_adjust_exists is
7346: select leclr.*
7347: from ben_le_clsn_n_rstr leclr
7348: ,ben_prtt_rt_val prv
7349: ,ben_acty_base_rt_f abr
7350: where bkup_tbl_typ_cd = 'BEN_PRTT_RT_VAL_ADJ'
7351: and bkup_tbl_id = prv.prtt_rt_val_id
7352: and prv.acty_base_rt_id = abr.acty_base_rt_id
7353: and abr.element_type_id = p_element_type_id;

Line 8152: from ben_acty_base_rt_f abr

8148: abr.ele_rqd_flag,
8149: abr.one_ann_pymt_cd,
8150: abr.entr_ann_val_flag,
8151: abr.ele_entry_val_cd
8152: from ben_acty_base_rt_f abr
8153: where abr.acty_base_rt_id=p_acty_base_rt_id
8154: and abr.business_group_id=p_business_group_id
8155: and p_effective_date between
8156: abr.effective_start_date and abr.effective_end_date;

Line 8640: from ben_acty_base_rt_f abr

8636: abr.one_ann_pymt_cd,
8637: abr.entr_ann_val_flag,
8638: abr.ele_entry_val_cd,
8639: abr.name
8640: from ben_acty_base_rt_f abr
8641: where abr.acty_base_rt_id=p_acty_base_rt_id
8642: and abr.business_group_id=p_business_group_id
8643: and p_effective_date between
8644: abr.effective_start_date and abr.effective_end_date;

Line 8768: from ben_acty_base_rt_f abr

8764: -- and prv.rt_strt_dt <=c_effective_date
8765: and prv.prtt_rt_val_stat_cd is null
8766: and prv.acty_base_rt_id in
8767: (select abr.acty_base_rt_id
8768: from ben_acty_base_rt_f abr
8769: where abr.acty_base_rt_id = prv.acty_base_rt_id
8770: and abr.element_type_id = c_element_type_id
8771: and c_effective_date between abr.effective_start_date
8772: and abr.effective_end_date);