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_PRTT_RT_VAL

Line 136: from ben_prtt_rt_val prv

132: prv.per_in_ler_id,
133: prv.element_entry_value_id,
134: prv.prtt_reimbmt_rqst_id,
135: prv.object_version_number
136: from ben_prtt_rt_val prv
137: where prtt_rt_val_id = c_prtt_rt_val_id;
138: --
139: l_prv_rec c_get_prtt_rt_val%ROWTYPE;
140: --

Line 2564: ben_prtt_rt_val prv,

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

Line 2675: FROM ben_prtt_rt_val

2671:
2672:
2673: cursor get_pil is
2674: SELECT per_in_ler_id
2675: FROM ben_prtt_rt_val
2676: WHERE prtt_rt_val_id = p_prtt_rt_val_id;
2677:
2678: cursor c_prv_change(p_per_in_ler_id number) is
2679: SELECT 'X'

Line 2680: FROM ben_prtt_rt_val

2676: WHERE prtt_rt_val_id = p_prtt_rt_val_id;
2677:
2678: cursor c_prv_change(p_per_in_ler_id number) is
2679: SELECT 'X'
2680: FROM ben_prtt_rt_val
2681: WHERE prtt_enrt_rslt_id = p_enrt_rslt_id
2682: AND ended_per_in_ler_id = p_per_in_ler_id
2683: AND ann_rt_val = p_annual_amt;
2684:

Line 2705: FROM ben_prtt_rt_val

2701: FROM pay_element_entry_values_f
2702: WHERE element_entry_value_id IN
2703: (
2704: SELECT element_entry_value_id
2705: FROM ben_prtt_rt_val
2706: WHERE prtt_enrt_rslt_id = p_enrt_rslt_id
2707: AND prtt_rt_val_stat_cd IS NULL
2708: )
2709: AND effective_start_date >= l_pp_start_dt

Line 2905: ben_prtt_rt_val prv

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
2909: and abr.acty_base_rt_id = prv.acty_base_rt_id

Line 2924: ben_prtt_rt_val prv1

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
2928: and pen1.prtt_enrt_rslt_stat_cd is null

Line 3117: from ben_prtt_rt_val prv,

3113: , p_rt_start_date in date
3114: )
3115: is
3116: select ler.name name, ler.ler_id ler_id
3117: from ben_prtt_rt_val prv,
3118: ben_per_in_ler pil,
3119: ben_ler_f ler
3120: where prv.per_in_ler_id = pil.per_in_ler_id
3121: and pil.ler_id = ler.ler_id

Line 3134: ben_prtt_rt_val prv,

3130: cursor c_enrt_rt
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

Line 3197: select prv.* from ben_prtt_rt_val prv,

3193: cursor c_get_prv_id(l_element_type_id number,
3194: l_input_value_id number,
3195: l_normal_pp_dt date,
3196: l_ELEMENT_ENTRY_ID number) is
3197: select prv.* from ben_prtt_rt_val prv,
3198: pay_element_entries_f et,
3199: pay_element_entry_values_f ev
3200: where et.element_type_id = l_element_type_id
3201: and ev.input_value_id = l_input_value_id

Line 3378: ben_prtt_rt_val prv

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
3382: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 3400: from ben_prtt_rt_val prv

3396:
3397: cursor c_dup_prv_chk (c_element_entry_id number,
3398: c_effective_date date) is
3399: select count(prv.prtt_enrt_rslt_id)
3400: from ben_prtt_rt_val prv
3401: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3402: and prv.acty_base_rt_id <> p_acty_base_rt_id
3403: and prv.rt_end_dt > c_effective_date
3404: and prv.prtt_rt_val_stat_cd is null

Line 3433: ben_prtt_rt_val prv,

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
3437: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 3456: ben_prtt_rt_val prv,

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
3460: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 3551: from ben_prtt_rt_val prv

3547: l_element_entry_values c_element_entry_values%ROWTYPE;
3548:
3549: cursor c_get_input_value(p_prtt_rt_val_id number, p_rt_start_date date) is
3550: select rt_val
3551: from ben_prtt_rt_val prv
3552: where prv.prtt_rt_val_id = p_prtt_rt_val_id
3553: and p_rt_start_date between prv.rt_strt_dt
3554: and prv.rt_end_dt;
3555:

Line 3749: ben_prtt_rt_val_api.update_prtt_rt_val

3745: --
3746: p_prv_object_version_number := nvl(p_prv_object_version_number,
3747: l_prv_rec.object_version_number);
3748:
3749: ben_prtt_rt_val_api.update_prtt_rt_val
3750: (p_validate => p_validate
3751: ,p_person_id => p_person_id
3752: ,p_prtt_rt_val_id => p_prtt_rt_val_id
3753: ,p_business_group_id => p_business_group_id

Line 4010: ben_prtt_rt_val_api.update_prtt_rt_val

4006: --
4007: p_prv_object_version_number := nvl(p_prv_object_version_number,
4008: l_prv_rec.object_version_number);
4009:
4010: ben_prtt_rt_val_api.update_prtt_rt_val
4011: (p_validate => p_validate
4012: ,p_person_id => p_person_id
4013: ,p_prtt_rt_val_id => p_prtt_rt_val_id
4014: ,p_business_group_id => p_business_group_id

Line 6528: ben_prtt_rt_val_api.update_prtt_rt_val(

6524: p_input_value_id,
6525: l_normal_pp_date,
6526: l_entry_exists.ELEMENT_ENTRY_ID) loop
6527: hr_utility.set_location(' j.prtt_rt_val_id '|| j.prtt_rt_val_id,44333);
6528: ben_prtt_rt_val_api.update_prtt_rt_val(
6529: p_validate => p_validate
6530: ,p_prtt_rt_val_id => j.prtt_rt_val_id
6531: ,p_element_entry_value_id => NULL
6532: ,p_object_version_number => j.object_version_number

Line 7141: ben_prtt_rt_val_api.update_prtt_rt_val

7137: --
7138: if p_prtt_rt_val_id is not null then
7139: p_prv_object_version_number := nvl(p_prv_object_version_number,
7140: l_prv_rec.object_version_number);
7141: ben_prtt_rt_val_api.update_prtt_rt_val
7142: (p_validate => p_validate
7143: ,p_business_group_id => l_prv_rec.business_group_id
7144: ,p_prtt_rt_val_id => l_prv_rec.prtt_rt_val_id
7145: ,p_element_entry_value_id => l_entry_value_id

Line 7348: ,ben_prtt_rt_val prv

7344: --
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

Line 7350: where bkup_tbl_typ_cd = 'BEN_PRTT_RT_VAL_ADJ'

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;
7354: --

Line 8496: ben_prtt_rt_val_api.update_prtt_rt_val

8492: l_prv_object_version_number := l_prv_rec.object_version_number;
8493:
8494: -- update the prv with the new element_entry_id
8495: --
8496: ben_prtt_rt_val_api.update_prtt_rt_val
8497: (p_validate => p_validate
8498: ,p_person_id => p_person_id
8499: ,p_prtt_rt_val_id => l_prv_rec.prtt_rt_val_id
8500: ,p_business_group_id => l_prv_rec.business_group_id

Line 8742: from ben_prtt_rt_val prv

8738: --already processed.
8739: cursor c_dup_prv(c_element_entry_id number,
8740: c_effective_date date) is
8741: select 'x'
8742: from ben_prtt_rt_val prv
8743: where prv.prtt_enrt_rslt_id = p_enrt_rslt_id
8744: and prv.acty_base_rt_id <> p_acty_base_rt_id
8745: and prv.rt_end_dt > c_effective_date
8746: -- and prv.rt_strt_dt <=c_effective_date

Line 8760: from ben_prtt_rt_val prv

8756: -- Bug 7597154: Modified cursor c_dup_prv
8757: cursor c_dup_prv(c_element_type_id number,
8758: c_effective_date date) is
8759: select 'x'
8760: from ben_prtt_rt_val prv
8761: where prv.prtt_enrt_rslt_id = p_enrt_rslt_id
8762: and prv.acty_base_rt_id <> p_acty_base_rt_id
8763: and prv.rt_end_dt > c_effective_date
8764: -- and prv.rt_strt_dt <=c_effective_date

Line 8795: from ben_prtt_rt_val prt,

8791: select pil.lf_evt_ocrd_dt,
8792: pil.trgr_table_pk_id,
8793: pil.per_in_ler_id,
8794: ler.ler_id
8795: from ben_prtt_rt_val prt,
8796: ben_per_in_ler pil,
8797: ben_ler_f ler
8798: where prt.prtt_rt_val_id = c_prtt_rt_val_id
8799: -- ended_per_in_ler_id may be null in case of back out

Line 8832: from ben_prtt_rt_val prv,

8828: , p_rt_end_date in date
8829: )
8830: is
8831: select ler.name name, ler.ler_id ler_id
8832: from ben_prtt_rt_val prv,
8833: ben_per_in_ler pil,
8834: ben_ler_f ler
8835: where prv.per_in_ler_id = pil.per_in_ler_id
8836: and pil.ler_id = ler.ler_id

Line 8886: ben_prtt_rt_val prv

8882:
8883: cursor c_get_prev_ele(p_rt_end_date date) is
8884: SELECT pev.*
8885: FROM pay_element_entry_values_f pev,
8886: ben_prtt_rt_val prv
8887: WHERE prv.prtt_rt_val_id = p_prtt_rt_val_id
8888: AND prv.rt_end_dt = p_rt_end_date
8889: AND prv.element_entry_value_id = pev.element_entry_value_id
8890: and p_rt_end_date between pev.effective_start_date and pev.effective_end_date;