eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1523: from ben_acty_base_rt_f abr

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

Line 1529: l_name ben_acty_base_rt_f.name%TYPE ;

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

Line 2531: ben_acty_base_rt_f abr

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

Line 2680: from ben_acty_base_rt_f abr

2676: abr.rcrrg_cd,
2677: abr.name
2678: -- bug 6441505
2679: ,abr.element_det_rl
2680: from ben_acty_base_rt_f abr
2681: where abr.acty_base_rt_id=c_acty_base_rt_id
2682: and c_effective_date between abr.effective_start_date
2683: and abr.effective_end_date;
2684: --

Line 2773: ben_acty_base_rt_f abr,

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

Line 2792: ben_acty_base_rt_f abr1,

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

Line 2933: from ben_acty_base_rt_f abr,

2929: )
2930: is
2931: select abr2.rt_mlt_cd,
2932: abr2.entr_ann_val_flag
2933: from ben_acty_base_rt_f abr,
2934: ben_acty_base_rt_f abr2
2935: where abr.acty_base_rt_id = c_acty_base_rt_id
2936: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
2937: and abr2.parnt_chld_cd = 'PARNT'

Line 2934: ben_acty_base_rt_f abr2

2930: is
2931: select abr2.rt_mlt_cd,
2932: abr2.entr_ann_val_flag
2933: from ben_acty_base_rt_f abr,
2934: ben_acty_base_rt_f abr2
2935: where abr.acty_base_rt_id = c_acty_base_rt_id
2936: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
2937: and abr2.parnt_chld_cd = 'PARNT'
2938: and c_effective_date

Line 3001: ben_acty_base_rt_f abr

2997: is
2998: SELECT ecr.enrt_rt_id
2999: FROM ben_enrt_rt ecr,
3000: ben_prtt_rt_val prv,
3001: ben_acty_base_rt_f abr
3002: WHERE prv.prtt_rt_val_id = ecr.prtt_rt_val_id
3003: AND prv.prtt_rt_val_stat_cd is NULL
3004: AND abr.acty_base_rt_id = prv.acty_base_rt_id
3005: AND ecr.acty_base_rt_id = prv.acty_base_rt_id

Line 3260: ben_acty_base_rt_f abr

3256: pev.input_value_id,
3257: abr.ele_entry_val_cd -- Bug 5575402
3258: from pay_element_entries_f pee,
3259: pay_element_entry_values_f pev,
3260: ben_acty_base_rt_f abr
3261: where pev.element_entry_value_id = l_ee_id
3262: and pee.element_entry_id = pev.element_entry_id
3263: and pev.effective_start_date between pee.effective_start_date
3264: and pee.effective_end_date

Line 6665: from ben_acty_base_rt_f abr

6661: abr.input_va_calc_rl,
6662: abr.element_type_id,
6663: abr.input_value_id,
6664: abr.prtl_mo_det_mthd_cd
6665: from ben_acty_base_rt_f abr
6666: where abr.acty_base_rt_id=p_acty_base_rt_id
6667: and p_effective_date between
6668: abr.effective_start_date and abr.effective_end_date;
6669: --

Line 6788: ,ben_acty_base_rt_f abr

6784: Cursor c_adjust_exists is
6785: select leclr.*
6786: from ben_le_clsn_n_rstr leclr
6787: ,ben_prtt_rt_val prv
6788: ,ben_acty_base_rt_f abr
6789: where bkup_tbl_typ_cd = 'BEN_PRTT_RT_VAL_ADJ'
6790: and bkup_tbl_id = prv.prtt_rt_val_id
6791: and prv.acty_base_rt_id = abr.acty_base_rt_id
6792: and abr.element_type_id = p_element_type_id;

Line 7591: from ben_acty_base_rt_f abr

7587: abr.ele_rqd_flag,
7588: abr.one_ann_pymt_cd,
7589: abr.entr_ann_val_flag,
7590: abr.ele_entry_val_cd
7591: from ben_acty_base_rt_f abr
7592: where abr.acty_base_rt_id=p_acty_base_rt_id
7593: and abr.business_group_id=p_business_group_id
7594: and p_effective_date between
7595: abr.effective_start_date and abr.effective_end_date;

Line 8079: from ben_acty_base_rt_f abr

8075: abr.one_ann_pymt_cd,
8076: abr.entr_ann_val_flag,
8077: abr.ele_entry_val_cd,
8078: abr.name
8079: from ben_acty_base_rt_f abr
8080: where abr.acty_base_rt_id=p_acty_base_rt_id
8081: and abr.business_group_id=p_business_group_id
8082: and p_effective_date between
8083: abr.effective_start_date and abr.effective_end_date;