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_LF_EVT_CLPS_RESTORE dependencies on BEN_PRTT_RT_VAL

Line 3091: from ben_prtt_rt_val prv

3087: l_differ varchar2(1) := 'N';
3088: --
3089: cursor c_bckdt_prv is
3090: select prv.*
3091: from ben_prtt_rt_val prv
3092: where prv.prtt_enrt_rslt_id = p_bckdt_pen_id
3093: and prv.business_group_id = p_business_group_id;
3094: --
3095: cursor c_curr_prv is

Line 3097: from ben_prtt_rt_val prv

3093: and prv.business_group_id = p_business_group_id;
3094: --
3095: cursor c_curr_prv is
3096: select prv.*
3097: from ben_prtt_rt_val prv
3098: where prv.prtt_enrt_rslt_id = p_curr_pen_id
3099: and prv.business_group_id = p_business_group_id;
3100: --
3101: TYPE l_bckdt_prv_rec is TABLE OF c_bckdt_prv%rowtype

Line 3118: from ben_prtt_rt_val prv

3114: --
3115: hr_utility.set_location ('Entering '||l_proc,10);
3116: --
3117: select count(*) into l_bckdt_prv_count
3118: from ben_prtt_rt_val prv
3119: where prv.prtt_enrt_rslt_id = p_bckdt_pen_id
3120: and prv.business_group_id = p_business_group_id;
3121: --
3122: l_curr_prv_table.delete;

Line 3258: -- ben_prtt_rt_val

3254: -- Following are the tables whose data will be compared to
3255: -- find any differences exists between the two runs of same ler.
3256: --
3257: -- ben_prtt_enrt_rslt_f
3258: -- ben_prtt_rt_val
3259: --
3260: l_bckdt_pen_cnt number := 0;
3261: l_bckdt_pen_cnt_temp number := 0;
3262: l_curr_pen_cnt number := 0;

Line 6396: from ben_prtt_rt_val prv

6392: --
6393: cursor c_prv(cv_prtt_enrt_rslt_id in number,
6394: cv_acty_base_rt_id in number) is
6395: select prv.*
6396: from ben_prtt_rt_val prv
6397: where prv.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
6398: and prv.per_in_ler_id = p_bckdt_per_in_ler_id
6399: and prv.business_group_id = p_business_group_id
6400: and prv.acty_base_rt_id = cv_acty_base_rt_id;

Line 6429: from ben_prtt_rt_val prv1, ben_prtt_rt_val prv2

6425: ,v_new_pen_id number ) is
6426: select prv2.prtt_rt_val_id new_prv_id,
6427: prv2.object_version_number new_prv_ovn,
6428: prv1.*
6429: from ben_prtt_rt_val prv1, ben_prtt_rt_val prv2
6430: where prv1.prtt_enrt_rslt_id = v_bckdt_pen_id
6431: and prv2.prtt_enrt_rslt_id = v_new_pen_id
6432: and prv1.acty_base_rt_id = prv2.acty_base_rt_id
6433: and prv1.rt_ovridn_flag = 'Y'

Line 6467: from ben_prtt_rt_val prv,

6463: cursor c_prv_ovn (v_prtt_rt_val_id number) is
6464: select prv.*
6465: ,abr.input_value_id
6466: ,abr.element_type_id
6467: from ben_prtt_rt_val prv,
6468: ben_acty_base_rt_f abr
6469: where prtt_rt_val_id = v_prtt_rt_val_id
6470: and abr.acty_base_rt_id=prv.acty_base_rt_id
6471: and abr.business_group_id = p_business_group_id

Line 6868: ben_prtt_rt_val_api.update_prtt_rt_val

6864: end if;
6865: end if;
6866: close c_prv_ovn;
6867: if l_upd_rt_val then
6868: ben_prtt_rt_val_api.update_prtt_rt_val
6869: (p_prtt_rt_val_id => l_prtt_rt_val_table(i)
6870: ,p_person_id => p_person_id
6871: ,p_rt_val => l_rt_table(i).calc_val
6872: ,p_acty_ref_perd_cd => l_prv_ovn.acty_ref_perd_cd

Line 7350: ben_prtt_rt_val_api.update_prtt_rt_val

7346: hr_utility.set_location('Updating new prv: ' || l_rt_rec.new_prv_id ||
7347: ' with overriden prv_id: ' ||
7348: l_rt_rec.prtt_rt_val_id, 72);
7349: --
7350: ben_prtt_rt_val_api.update_prtt_rt_val
7351: (p_prtt_rt_val_id => l_rt_rec.new_prv_id
7352: ,p_person_id => p_person_id
7353: ,p_rt_strt_dt => l_rt_rec.rt_strt_dt
7354: ,p_rt_val => l_rt_rec.rt_val

Line 8130: from ben_prtt_rt_val prv

8126: --
8127: cursor c_prv(cv_prtt_enrt_rslt_id in number,
8128: cv_acty_base_rt_id in number) is
8129: select prv.*
8130: from ben_prtt_rt_val prv
8131: where prv.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
8132: and prv.per_in_ler_id = p_bckdt_per_in_ler_id
8133: and prv.business_group_id = p_business_group_id
8134: and prv.acty_base_rt_id = cv_acty_base_rt_id;

Line 8164: from ben_prtt_rt_val prv,

8160: cursor c_prv_ovn (v_prtt_rt_val_id number) is
8161: select prv.*
8162: ,abr.input_value_id
8163: ,abr.element_type_id
8164: from ben_prtt_rt_val prv,
8165: ben_acty_base_rt_f abr
8166: where prtt_rt_val_id = v_prtt_rt_val_id
8167: and abr.acty_base_rt_id=prv.acty_base_rt_id
8168: and abr.business_group_id = p_business_group_id

Line 8823: ben_prtt_rt_val_api.update_prtt_rt_val

8819: end if;
8820: end if;
8821: close c_prv_ovn;
8822: if l_upd_rt_val then
8823: ben_prtt_rt_val_api.update_prtt_rt_val
8824: (p_prtt_rt_val_id => l_prtt_rt_val_table(i)
8825: ,p_person_id => p_person_id
8826: ,p_rt_val => l_rt_table(i).calc_val
8827: ,p_acty_ref_perd_cd => l_prv_ovn.acty_ref_perd_cd

Line 9447: from ben_prtt_rt_val prv1, --backed out

9443: ,v_new_pen_id number ) is
9444: select prv2.prtt_rt_val_id new_prv_id,
9445: prv2.object_version_number new_prv_ovn,
9446: prv1.*
9447: from ben_prtt_rt_val prv1, --backed out
9448: ben_prtt_rt_val prv2 --current
9449: where prv1.prtt_enrt_rslt_id = v_bckdt_pen_id
9450: and prv2.prtt_enrt_rslt_id = v_new_pen_id
9451: and prv1.acty_base_rt_id = prv2.acty_base_rt_id

Line 9448: ben_prtt_rt_val prv2 --current

9444: select prv2.prtt_rt_val_id new_prv_id,
9445: prv2.object_version_number new_prv_ovn,
9446: prv1.*
9447: from ben_prtt_rt_val prv1, --backed out
9448: ben_prtt_rt_val prv2 --current
9449: where prv1.prtt_enrt_rslt_id = v_bckdt_pen_id
9450: and prv2.prtt_enrt_rslt_id = v_new_pen_id
9451: and prv1.acty_base_rt_id = prv2.acty_base_rt_id
9452: and prv1.rt_ovridn_flag = 'Y'

Line 9751: ben_prtt_rt_val_api.update_prtt_rt_val

9747: if l_override = 'Y' then
9748: --
9749: l_rate_flex_ovrrd_exists := 'Y';
9750: --
9751: ben_prtt_rt_val_api.update_prtt_rt_val
9752: (p_prtt_rt_val_id => l_rt_rec.new_prv_id
9753: ,p_person_id => p_person_id
9754: ,p_rt_strt_dt => l_rt_rec.rt_strt_dt
9755: ,p_rt_val => l_rt_rec.rt_val

Line 11713: from ben_prtt_rt_val prv

11709: --
11710: cursor c_prv(cv_prtt_enrt_rslt_id in number,
11711: cv_acty_base_rt_id in number) is
11712: select prv.*
11713: from ben_prtt_rt_val prv
11714: where prv.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
11715: and prv.per_in_ler_id = p_bckdt_per_in_ler_id
11716: and prv.business_group_id = p_business_group_id
11717: and prv.acty_base_rt_id = cv_acty_base_rt_id;

Line 11748: from ben_prtt_rt_val prv1, ben_prtt_rt_val prv2

11744: ,v_new_pen_id number ) is
11745: select prv2.prtt_rt_val_id new_prv_id,
11746: prv2.object_version_number new_prv_ovn,
11747: prv1.*
11748: from ben_prtt_rt_val prv1, ben_prtt_rt_val prv2
11749: where prv1.prtt_enrt_rslt_id = v_bckdt_pen_id
11750: and prv2.prtt_enrt_rslt_id = v_new_pen_id
11751: and prv1.acty_base_rt_id = prv2.acty_base_rt_id
11752: and prv1.rt_ovridn_flag = 'Y'

Line 11786: from ben_prtt_rt_val prv,

11782: cursor c_prv_ovn (v_prtt_rt_val_id number) is
11783: select prv.*
11784: ,abr.input_value_id
11785: ,abr.element_type_id
11786: from ben_prtt_rt_val prv,
11787: ben_acty_base_rt_f abr
11788: where prtt_rt_val_id = v_prtt_rt_val_id
11789: and abr.acty_base_rt_id=prv.acty_base_rt_id
11790: and abr.business_group_id = p_business_group_id

Line 12296: ben_prtt_rt_val_api.update_prtt_rt_val

12292: end if;
12293: end if;
12294: close c_prv_ovn;
12295: if l_upd_rt_val then
12296: ben_prtt_rt_val_api.update_prtt_rt_val
12297: (p_prtt_rt_val_id => l_prtt_rt_val_table(i)
12298: ,p_person_id => p_person_id
12299: ,p_rt_val => l_rt_table(i).calc_val
12300: ,p_acty_ref_perd_cd => l_prv_ovn.acty_ref_perd_cd

Line 12763: ben_prtt_rt_val_api.update_prtt_rt_val

12759: hr_utility.set_location('Updating new prv: ' || l_rt_rec.new_prv_id ||
12760: ' with overriden prv_id: ' ||
12761: l_rt_rec.prtt_rt_val_id, 72);
12762: --
12763: ben_prtt_rt_val_api.update_prtt_rt_val
12764: (p_prtt_rt_val_id => l_rt_rec.new_prv_id
12765: ,p_person_id => p_person_id
12766: ,p_rt_strt_dt => l_rt_rec.rt_strt_dt
12767: ,p_rt_val => l_rt_rec.rt_val