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 1041: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

1037: L_Elctbl_Flag Varchar2(1) := 'N';
1038: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1039: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
1040: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1041: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
1042: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
1043: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
1044: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1045: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;

Line 1042: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;

1038: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1039: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
1040: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1041: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
1042: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
1043: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
1044: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1045: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
1046: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 1043: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

1039: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
1040: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1041: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
1042: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
1043: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
1044: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1045: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
1046: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1047: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;

Line 1518: Ben_Enrt_Rt Rate

1514: Cursor Enrolment is
1515: Select Elctbl.PRTT_ENRT_RSLT_ID, Elctbl.Enrt_Cvg_Strt_Dt , Elctbl.Crntly_Enrd_Flag, Rate.ENRT_RT_ID, Rate.ENRT_BNFT_ID,
1516: Rate.Val , Elctbl.Business_Group_Id, Elctbl.Per_in_Ler_Id , Rate.ANN_VAL
1517: From Ben_Elig_Per_Elctbl_Chc Elctbl,
1518: Ben_Enrt_Rt Rate
1519: Where Elctbl.ELIG_PER_ELCTBL_CHC_ID = P_ELIG_PER_ELCTBL_CHC_ID
1520: and Rate.ELIG_PER_ELCTBL_CHC_ID = Elctbl.ELIG_PER_ELCTBL_CHC_ID;
1521:
1522: l_PRTT_ENRT_RSLT_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;

Line 1604: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;

1600: --
1601: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1602: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1603: l_person_id ben_per_in_ler.person_id%type;
1604: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1605: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1606: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1607: l_prev_sal ben_enrt_rt.val%type;
1608: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

Line 1605: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;

1601: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1602: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1603: l_person_id ben_per_in_ler.person_id%type;
1604: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1605: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1606: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1607: l_prev_sal ben_enrt_rt.val%type;
1608: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1609: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;

Line 1607: l_prev_sal ben_enrt_rt.val%type;

1603: l_person_id ben_per_in_ler.person_id%type;
1604: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1605: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1606: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1607: l_prev_sal ben_enrt_rt.val%type;
1608: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1609: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1610: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1611: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 1679: Ben_Enrt_Rt Rate

1675: --
1676: Cursor csr_prev_sal is
1677: Select Elct.Pgm_id, Rate.Rt_Strt_Dt Sal_Chg_Dt,Rate.Val Val
1678: From Ben_Elig_Per_Elctbl_Chc Elct,
1679: Ben_Enrt_Rt Rate
1680: Where Elct.DFLT_FLAG = 'Y'
1681: and Elct.Elctbl_Flag = 'Y'
1682: and Elct.Per_in_ler_id = l_Last_Per_In_ler_Id
1683: and Elct.Enrt_Cvg_Strt_Dt is Not NULL

Line 1690: Ben_Enrt_Rt Rate

1686: -- Check the last rate change date., not counting current one.
1687: Cursor csr_max_rt_change is
1688: Select max(Rate.Rt_Strt_Dt) Sal_Chg_Dt
1689: From Ben_Elig_Per_Elctbl_Chc Elct,
1690: Ben_Enrt_Rt Rate
1691: Where Elct.DFLT_FLAG = 'Y'
1692: and Elct.Elctbl_Flag = 'Y'
1693: and Elct.Per_in_ler_id in (Select pil.Per_in_Ler_Id
1694: From Ben_Per_in_ler PIL,

Line 1973: ben_Enrt_Rt Rate,

1969: Select Rate.Val , Rate.Rt_Strt_Dt, Rate.Prtt_Rt_Val_Id,
1970: Rate.Object_Version_Number, Enrt.Pgm_Id, Enrt.OiPl_Id,
1971: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id
1972: From Ben_ELig_per_Elctbl_Chc Enrt,
1973: ben_Enrt_Rt Rate,
1974: Ben_Per_in_ler PIL,
1975: Per_All_Assignments_F Asgt
1976: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1977: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id

Line 2874: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

2870: ,P_Sal_Chg_Dt IN Date
2871: ,P_Comments IN Varchar2
2872: ,P_Approve_Rej IN Varchar2) Is
2873:
2874: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
2875: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
2876:
2877: Cursor Enrt_Rt is
2878: Select Enrt_Rt_Id,

Line 2875: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;

2871: ,P_Comments IN Varchar2
2872: ,P_Approve_Rej IN Varchar2) Is
2873:
2874: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
2875: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
2876:
2877: Cursor Enrt_Rt is
2878: Select Enrt_Rt_Id,
2879: Object_Version_Number

Line 2880: From Ben_Enrt_Rt

2876:
2877: Cursor Enrt_Rt is
2878: Select Enrt_Rt_Id,
2879: Object_Version_Number
2880: From Ben_Enrt_Rt
2881: Where Elig_per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
2882:
2883: BEgin
2884:

Line 2898: Update Ben_Enrt_Rt

2894: ,Comments = P_Comments
2895: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
2896:
2897: If L_Enrt_Rt_Id is Not NULL and P_Sal_Chg_Dt is Not Null then
2898: Update Ben_Enrt_Rt
2899: Set Rt_Strt_Dt = P_Sal_Chg_Dt
2900: Where Enrt_Rt_Id = L_Enrt_Rt_Id;
2901: End If;
2902:

Line 3241: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

3237: L_Elctbl_Flag Varchar2(1) := 'N';
3238: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3239: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3240: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3241: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3242: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3243: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3244: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3245: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;

Line 3242: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;

3238: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3239: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3240: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3241: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3242: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3243: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3244: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3245: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
3246: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 3243: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

3239: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3240: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3241: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3242: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3243: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3244: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3245: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
3246: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3247: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;

Line 3551: l_ANN_VAL ben_enrt_rt.ann_val%TYPE;

3547: l_voidd_date date;
3548: l_per_in_ler_id number;
3549:
3550: l_ACTY_REF_PERD_CD ben_pgm_f.ACTY_REF_PERD_CD%TYPE;
3551: l_ANN_VAL ben_enrt_rt.ann_val%TYPE;
3552:
3553: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;
3554: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
3555:

Line 3561: ben_Enrt_Rt Rate,

3557: Select Rate.Val , Rate.Rt_Strt_Dt, Rate.Prtt_Rt_Val_Id,
3558: Rate.Object_Version_Number, Enrt.Pgm_Id, Enrt.OiPl_Id,
3559: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id,Pil.per_in_ler_id, Rate.Ann_val
3560: From Ben_ELig_per_Elctbl_Chc Enrt,
3561: ben_Enrt_Rt Rate,
3562: Ben_Per_in_ler PIL,
3563: Per_All_Assignments_F Asgt
3564: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
3565: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id

Line 3916: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;

3912: IS
3913: l_temp_prog_date date;
3914: l_temp_sal_chg_date date;
3915: l_temp_proposed_rank number;
3916: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3917: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
3918:
3919: Cursor Enrt_Rt is
3920: Select Enrt_Rt_Id,

Line 3917: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;

3913: l_temp_prog_date date;
3914: l_temp_sal_chg_date date;
3915: l_temp_proposed_rank number;
3916: L_Enrt_Rt_Id ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3917: l_Enrt_ovn ben_Enrt_Rt.Object_Version_Number%TYPE;
3918:
3919: Cursor Enrt_Rt is
3920: Select Enrt_Rt_Id,
3921: Object_Version_Number

Line 3922: From Ben_Enrt_Rt

3918:
3919: Cursor Enrt_Rt is
3920: Select Enrt_Rt_Id,
3921: Object_Version_Number
3922: From Ben_Enrt_Rt
3923: Where Elig_per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
3924:
3925: Begin
3926: if g_debug then

Line 3964: Update Ben_Enrt_Rt

3960: Set Enrt_Cvg_Strt_Dt = P_PROGRESSION_DATE
3961: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
3962:
3963: If L_Enrt_Rt_Id is Not NULL and P_Sal_Chg_Dt is Not Null then
3964: Update Ben_Enrt_Rt
3965: Set Rt_Strt_Dt = P_Sal_Chg_Dt
3966: Where Enrt_Rt_Id = L_Enrt_Rt_Id;
3967: End If;
3968: hr_utility.set_location(' Leaving call_from_webadi',10);