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_ELIG_PER_ELCTBL_CHC

Line 107: l_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

103: P_Date_track_Mode IN Varchar2,
104: P_Warning_Mesg OUT NOCOPY Varchar2) Is
105:
106: l_Pgm_Id BEN_PGM_F.Pgm_Id%TYPE;
107: l_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
108: l_Update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
109: l_Person_name Per_All_People_F.Full_name%TYPE;
110: l_Person_Id Per_All_People_F.Person_Id%TYPE;
111: l_Last_Name Per_All_People_F.Last_name%TYPE;

Line 196: From Ben_Elig_Per_Elctbl_Chc Elct,

192: And Pil.Per_In_Ler_Stat_Cd = 'PROCD';
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

Line 387: From Ben_Elig_per_Elctbl_Chc Elct,

383: P_Elig_per_Elctbl_Chc_Id IN Number) Is
384:
385: Cursor Pler is
386: Select Pler.Per_In_Ler_Id, Pler.Object_Version_Number, Elct.Pgm_Id
387: From Ben_Elig_per_Elctbl_Chc Elct,
388: Ben_Per_In_Ler Pler
389: Where Elct.Elig_per_Elctbl_Chc_Id = P_Elig_per_Elctbl_Chc_Id
390: and Pler.Per_In_Ler_Id = Elct.Per_In_Ler_Id;
391:

Line 846: from Ben_Elig_per_Elctbl_Chc

842: and Lrsn.Effective_End_Date;
843: -- 6519699
844: Cursor Curr_Enrollment (P_Pgm_Id in Number, P_Person_Id in Number, P_Ler_id in Number) is
845: Select Pl_Id, Oipl_Id
846: from Ben_Elig_per_Elctbl_Chc
847: Where Pgm_Id = P_Pgm_Id
848: and Dflt_Flag = 'Y'
849: and Elctbl_Flag = 'Y'
850: and Per_In_ler_Id = (Select Max(Per_In_ler_Id)

Line 929: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

925: l_Step_Exists Varchar2(1) := 'N';
926: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
927: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
928: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
929: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
930: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
931: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
932: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
933: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 930: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

926: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
927: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
928: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
929: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
930: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
931: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
932: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
933: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
934: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;

Line 932: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

928: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
929: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
930: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
931: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
932: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
933: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
934: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
935: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
936: L_Elctbl_Flag Varchar2(1) := 'N';

Line 933: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

929: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
930: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
931: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
932: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
933: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
934: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
935: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
936: L_Elctbl_Flag Varchar2(1) := 'N';
937: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

Line 943: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_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;
947: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;

Line 945: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%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;
947: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
948: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
949: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;

Line 1357: From Ben_Elig_Per_Elctbl_Chc Elctbl,

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

Line 1446: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_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;
1450: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;

Line 1497: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt

1493: -- Get current Per_in_ler
1494: --
1495: Cursor csr_curr_le is
1496: Select pil.Per_in_Ler_Id, pil.person_id
1497: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt
1498: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1499: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id;
1500: --And Pil.LF_EVT_OCRD_DT = P_Effective_Date;
1501: -- And Pil.Per_In_Ler_Stat_Cd = 'PROCD';

Line 1518: From Ben_Elig_Per_Elctbl_Chc Elct,

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

Line 1529: From Ben_Elig_Per_Elctbl_Chc Elct,

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

Line 1812: From Ben_ELig_per_Elctbl_Chc Enrt,

1808: Cursor Enroll_Info is
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

Line 2254: From Ben_Elig_Per_Elctbl_Chc Enrlmt,

2250: Select Enrlmt.PL_Id , Enrlmt.Pgm_Id , Enrlmt.Oipl_Id , Enrlmt.Business_Group_Id,
2251: Enrlmt.Enrt_Cvg_Strt_Dt, Pgm.Dflt_Step_CD, Pl.MAPPING_TABLE_PK_ID, Asgt.Assignment_Id,
2252: Asgt.Object_Version_Number , Asgt.SPECIAL_CEILING_STEP_ID, Asgt.People_Group_Id,
2253: Asgt.Soft_Coding_Keyflex_Id, Asgt.Grade_Id, Asgt.Grade_Ladder_Pgm_Id
2254: From Ben_Elig_Per_Elctbl_Chc Enrlmt,
2255: Ben_Per_in_ler PIL,
2256: Ben_Pgm_F Pgm,
2257: Ben_PLip_F Plip,
2258: Ben_Pl_F Pl,

Line 2345: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;

2341: l_entries_changed_warning Varchar2(250);
2342: l_tax_district_changed_warning Boolean;
2343: l_concatenated_segments Varchar2(250);
2344: L_DATE_TRACK_MODE Varchar2(25);
2345: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;
2346: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;
2347: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;
2348: Begin
2349:

Line 2528: From ben_Elig_Per_Elctbl_Chc Elct,

2524:
2525: Cursor Elctbl is
2526: Select Elct.ELIG_PER_ELCTBL_CHC_ID, Pil.Person_Id, Pil.Per_In_Ler_id, Pil. Object_Version_Number,
2527: Elct.Enrt_Cvg_Strt_Dt, Pgm.Update_Salary_Cd, Pgm.Dflt_Step_Cd, Elct.Approval_Status_Cd, Person.Full_name
2528: From ben_Elig_Per_Elctbl_Chc Elct,
2529: Ben_Ler_F Ler,
2530: Ben_Per_in_ler Pil,
2531: Ben_Pgm_F PGM,
2532: Per_All_People_F Person

Line 2731: Update Ben_Elig_per_elctbl_Chc

2727: Open Enrt_Rt;
2728: Fetch Enrt_Rt into L_Enrt_Rt_Id, l_Enrt_ovn;
2729: Close Enrt_Rt;
2730:
2731: Update Ben_Elig_per_elctbl_Chc
2732: Set Approval_Status_Cd = 'PQH_GSP_A'
2733: ,Enrt_Cvg_Strt_Dt = P_Prog_Dt
2734: ,Comments = P_Comments
2735: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;

Line 2745: Update Ben_Elig_per_elctbl_Chc

2741: End If;
2742:
2743: Elsif P_Approve_Rej = 'PQH_GSP_R' Then
2744:
2745: Update Ben_Elig_per_elctbl_Chc
2746: Set Approval_Status_Cd = 'PQH_GSP_R'
2747: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
2748:
2749: End If;

Line 3070: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

3066: l_Step_Exists Varchar2(1) := 'N';
3067: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
3068: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
3069: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3070: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3071: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3072: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3073: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3074: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 3071: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

3067: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
3068: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
3069: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3070: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3071: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3072: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3073: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3074: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3075: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;

Line 3073: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

3069: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3070: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3071: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3072: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3073: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3074: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3075: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3076: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3077: L_Elctbl_Flag Varchar2(1) := 'N';

Line 3074: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

3070: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3071: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3072: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3073: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3074: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3075: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3076: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3077: L_Elctbl_Flag Varchar2(1) := 'N';
3078: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

Line 3084: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_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;
3088: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;

Line 3086: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%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;
3088: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
3089: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
3090: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;

Line 3339: from Ben_ELig_per_Elctbl_Chc

3335: */
3336: Cursor csr_elct_chcs
3337: is
3338: Select Elig_per_Elctbl_Chc_Id,COMP_LVL_CD,pgm_id
3339: from Ben_ELig_per_Elctbl_Chc
3340: where per_in_ler_id = p_per_in_ler_id;
3341:
3342: Cursor csr_pil_dtls
3343: IS

Line 3400: From Ben_ELig_per_Elctbl_Chc Enrt,

3396: Cursor Enroll_Info(P_Elig_per_Elctbl_Chc_Id in number) is
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

Line 3799: Update Ben_Elig_per_elctbl_Chc

3795: ,p_pgm_id => p_grade_ladder_id
3796: ,p_pl_id => p_pl_id
3797: );
3798:
3799: Update Ben_Elig_per_elctbl_Chc
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