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.PQH_GSP_POST_PROCESS dependencies on BEN_ENRT_RT

Line 118: l_Lst_Rt_Chg_Dt Ben_Enrt_Rt.Rt_Strt_Dt%TYPE;

114: l_Dflt_Step_Cd Ben_Pgm_F.Dflt_Step_Cd%TYPE;
115: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
116: l_Mass_update_Call Varchar2(1) := 'N';
117: l_Last_Per_In_ler_Id Ben_Per_In_ler.Per_in_ler_Id%TYPE;
118: l_Lst_Rt_Chg_Dt Ben_Enrt_Rt.Rt_Strt_Dt%TYPE;
119: l_Le_Exists Varchar2(1);
120:
121: Cursor Person_Dtls is
122: Select Full_name, Last_NAME, Person.Person_Id, Asgt.Grade_id, Asgt.Grade_Ladder_Pgm_Id

Line 197: Ben_Enrt_Rt Rate

193: ---
194: Cursor csr_sal is
195: Select Rate.Rt_Strt_Dt Sal_Chg_Dt
196: From Ben_Elig_Per_Elctbl_Chc Elct,
197: Ben_Enrt_Rt Rate
198: Where Elct.DFLT_FLAG = 'Y'
199: and Elct.Elctbl_Flag = 'Y'
200: and Elct.Per_in_ler_id = l_Last_Per_In_ler_Id
201: and Elct.Enrt_Cvg_Strt_Dt is Not NULL

Line 940: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

936: L_Elctbl_Flag Varchar2(1) := 'N';
937: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
938: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
939: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
940: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
941: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
942: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
943: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
944: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;

Line 941: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;

937: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
938: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
939: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
940: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
941: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
942: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
943: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
944: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
945: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 942: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

938: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
939: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
940: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
941: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
942: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
943: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
944: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
945: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
946: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;

Line 1358: Ben_Enrt_Rt Rate

1354: Cursor Enrolment is
1355: Select Elctbl.PRTT_ENRT_RSLT_ID, Elctbl.Enrt_Cvg_Strt_Dt , Elctbl.Crntly_Enrd_Flag, Rate.ENRT_RT_ID, Rate.ENRT_BNFT_ID,
1356: Rate.Val , Elctbl.Business_Group_Id, Elctbl.Per_in_Ler_Id , Rate.ANN_VAL
1357: From Ben_Elig_Per_Elctbl_Chc Elctbl,
1358: Ben_Enrt_Rt Rate
1359: Where Elctbl.ELIG_PER_ELCTBL_CHC_ID = P_ELIG_PER_ELCTBL_CHC_ID
1360: and Rate.ELIG_PER_ELCTBL_CHC_ID = Elctbl.ELIG_PER_ELCTBL_CHC_ID;
1361:
1362: l_PRTT_ENRT_RSLT_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;

Line 1444: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;

1440: --
1441: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1442: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1443: l_person_id ben_per_in_ler.person_id%type;
1444: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1445: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1446: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1447: l_prev_sal ben_enrt_rt.val%type;
1448: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

Line 1445: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;

1441: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1442: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1443: l_person_id ben_per_in_ler.person_id%type;
1444: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1445: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1446: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1447: l_prev_sal ben_enrt_rt.val%type;
1448: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1449: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;

Line 1447: l_prev_sal ben_enrt_rt.val%type;

1443: l_person_id ben_per_in_ler.person_id%type;
1444: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1445: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1446: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1447: l_prev_sal ben_enrt_rt.val%type;
1448: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1449: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1450: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1451: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 1519: Ben_Enrt_Rt Rate

1515: --
1516: Cursor csr_prev_sal is
1517: Select Elct.Pgm_id, Rate.Rt_Strt_Dt Sal_Chg_Dt,Rate.Val Val
1518: From Ben_Elig_Per_Elctbl_Chc Elct,
1519: Ben_Enrt_Rt Rate
1520: Where Elct.DFLT_FLAG = 'Y'
1521: and Elct.Elctbl_Flag = 'Y'
1522: and Elct.Per_in_ler_id = l_Last_Per_In_ler_Id
1523: and Elct.Enrt_Cvg_Strt_Dt is Not NULL

Line 1530: Ben_Enrt_Rt Rate

1526: -- Check the last rate change date., not counting current one.
1527: Cursor csr_max_rt_change is
1528: Select max(Rate.Rt_Strt_Dt) Sal_Chg_Dt
1529: From Ben_Elig_Per_Elctbl_Chc Elct,
1530: Ben_Enrt_Rt Rate
1531: Where Elct.DFLT_FLAG = 'Y'
1532: and Elct.Elctbl_Flag = 'Y'
1533: and Elct.Per_in_ler_id in (Select pil.Per_in_Ler_Id
1534: From Ben_Per_in_ler PIL,

Line 1813: ben_Enrt_Rt Rate,

1809: Select Rate.Val , Rate.Rt_Strt_Dt, Rate.Prtt_Rt_Val_Id,
1810: Rate.Object_Version_Number, Enrt.Pgm_Id, Enrt.OiPl_Id,
1811: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id
1812: From Ben_ELig_per_Elctbl_Chc Enrt,
1813: ben_Enrt_Rt Rate,
1814: Ben_Per_in_ler PIL,
1815: Per_All_Assignments_F Asgt
1816: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1817: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id

Line 2714: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

2710: ,P_Sal_Chg_Dt IN Date
2711: ,P_Comments IN Varchar2
2712: ,P_Approve_Rej IN Varchar2) Is
2713:
2714: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
2715: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
2716:
2717: Cursor Enrt_Rt is
2718: Select Enrt_Rt_Id,

Line 2715: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;

2711: ,P_Comments IN Varchar2
2712: ,P_Approve_Rej IN Varchar2) Is
2713:
2714: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
2715: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
2716:
2717: Cursor Enrt_Rt is
2718: Select Enrt_Rt_Id,
2719: Object_Version_Number

Line 2720: From Ben_Enrt_Rt

2716:
2717: Cursor Enrt_Rt is
2718: Select Enrt_Rt_Id,
2719: Object_Version_Number
2720: From Ben_Enrt_Rt
2721: Where Elig_per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
2722:
2723: BEgin
2724:

Line 2738: Update Ben_Enrt_Rt

2734: ,Comments = P_Comments
2735: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
2736:
2737: If L_Enrt_Rt_Id is Not NULL and P_Sal_Chg_Dt is Not Null then
2738: Update Ben_Enrt_Rt
2739: Set Rt_Strt_Dt = P_Sal_Chg_Dt
2740: Where Enrt_Rt_Id = L_Enrt_Rt_Id;
2741: End If;
2742:

Line 3081: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

3077: L_Elctbl_Flag Varchar2(1) := 'N';
3078: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3079: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3080: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3081: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3082: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3083: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3084: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3085: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;

Line 3082: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;

3078: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3079: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3080: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3081: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3082: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3083: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3084: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3085: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
3086: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 3083: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

3079: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3080: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3081: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3082: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3083: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3084: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3085: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
3086: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3087: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;

Line 3391: l_ANN_VAL ben_enrt_rt.ann_val%TYPE;

3387: l_voidd_date date;
3388: l_per_in_ler_id number;
3389:
3390: l_ACTY_REF_PERD_CD ben_pgm_f.ACTY_REF_PERD_CD%TYPE;
3391: l_ANN_VAL ben_enrt_rt.ann_val%TYPE;
3392:
3393: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;
3394: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
3395:

Line 3401: ben_Enrt_Rt Rate,

3397: Select Rate.Val , Rate.Rt_Strt_Dt, Rate.Prtt_Rt_Val_Id,
3398: Rate.Object_Version_Number, Enrt.Pgm_Id, Enrt.OiPl_Id,
3399: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id,Pil.per_in_ler_id, Rate.Ann_val
3400: From Ben_ELig_per_Elctbl_Chc Enrt,
3401: ben_Enrt_Rt Rate,
3402: Ben_Per_in_ler PIL,
3403: Per_All_Assignments_F Asgt
3404: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
3405: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id

Line 3756: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

3752: IS
3753: l_temp_prog_date date;
3754: l_temp_sal_chg_date date;
3755: l_temp_proposed_rank number;
3756: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3757: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
3758:
3759: Cursor Enrt_Rt is
3760: Select Enrt_Rt_Id,

Line 3757: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;

3753: l_temp_prog_date date;
3754: l_temp_sal_chg_date date;
3755: l_temp_proposed_rank number;
3756: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3757: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
3758:
3759: Cursor Enrt_Rt is
3760: Select Enrt_Rt_Id,
3761: Object_Version_Number

Line 3762: From Ben_Enrt_Rt

3758:
3759: Cursor Enrt_Rt is
3760: Select Enrt_Rt_Id,
3761: Object_Version_Number
3762: From Ben_Enrt_Rt
3763: Where Elig_per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
3764:
3765: Begin
3766: if g_debug then

Line 3804: Update Ben_Enrt_Rt

3800: Set Enrt_Cvg_Strt_Dt = P_PROGRESSION_DATE
3801: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
3802:
3803: If L_Enrt_Rt_Id is Not NULL and P_Sal_Chg_Dt is Not Null then
3804: Update Ben_Enrt_Rt
3805: Set Rt_Strt_Dt = P_Sal_Chg_Dt
3806: Where Enrt_Rt_Id = L_Enrt_Rt_Id;
3807: End If;
3808: hr_utility.set_location(' Leaving call_from_webadi',10);