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 428: From Ben_Elig_per_Elctbl_Chc Elct,

424: P_Elig_per_Elctbl_Chc_Id IN Number) Is
425:
426: Cursor Pler is
427: Select Pler.Per_In_Ler_Id, Pler.Object_Version_Number, Elct.Pgm_Id
428: From Ben_Elig_per_Elctbl_Chc Elct,
429: Ben_Per_In_Ler Pler
430: Where Elct.Elig_per_Elctbl_Chc_Id = P_Elig_per_Elctbl_Chc_Id
431: and Pler.Per_In_Ler_Id = Elct.Per_In_Ler_Id;
432:

Line 887: from Ben_Elig_per_Elctbl_Chc

883: and Lrsn.Effective_End_Date;
884: -- 6519699
885: Cursor Curr_Enrollment (P_Pgm_Id in Number, P_Person_Id in Number, P_Ler_id in Number) is
886: Select Pl_Id, Oipl_Id
887: from Ben_Elig_per_Elctbl_Chc
888: Where Pgm_Id = P_Pgm_Id
889: and Dflt_Flag = 'Y'
890: and Elctbl_Flag = 'Y'
891: and Per_In_ler_Id = (Select Max(Per_In_ler_Id)

Line 1030: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

1026: l_Step_Exists Varchar2(1) := 'N';
1027: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
1028: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
1029: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
1030: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1031: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1032: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
1033: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1034: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 1031: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

1027: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
1028: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
1029: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
1030: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1031: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1032: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
1033: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1034: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1035: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;

Line 1033: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

1029: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
1030: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1031: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1032: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
1033: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1034: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1035: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
1036: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1037: L_Elctbl_Flag Varchar2(1) := 'N';

Line 1034: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

1030: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1031: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1032: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
1033: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1034: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1035: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
1036: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1037: L_Elctbl_Flag Varchar2(1) := 'N';
1038: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

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

Line 1046: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%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;
1048: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
1049: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
1050: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;

Line 1517: From Ben_Elig_Per_Elctbl_Chc Elctbl,

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

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

Line 1657: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt

1653: -- Get current Per_in_ler
1654: --
1655: Cursor csr_curr_le is
1656: Select pil.Per_in_Ler_Id, pil.person_id
1657: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt
1658: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1659: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id;
1660: --And Pil.LF_EVT_OCRD_DT = P_Effective_Date;
1661: -- And Pil.Per_In_Ler_Stat_Cd = 'PROCD';

Line 1678: From Ben_Elig_Per_Elctbl_Chc Elct,

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

Line 1689: From Ben_Elig_Per_Elctbl_Chc Elct,

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

Line 1972: From Ben_ELig_per_Elctbl_Chc Enrt,

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

Line 2414: From Ben_Elig_Per_Elctbl_Chc Enrlmt,

2410: Select Enrlmt.PL_Id , Enrlmt.Pgm_Id , Enrlmt.Oipl_Id , Enrlmt.Business_Group_Id,
2411: Enrlmt.Enrt_Cvg_Strt_Dt, Pgm.Dflt_Step_CD, Pl.MAPPING_TABLE_PK_ID, Asgt.Assignment_Id,
2412: Asgt.Object_Version_Number , Asgt.SPECIAL_CEILING_STEP_ID, Asgt.People_Group_Id,
2413: Asgt.Soft_Coding_Keyflex_Id, Asgt.Grade_Id, Asgt.Grade_Ladder_Pgm_Id
2414: From Ben_Elig_Per_Elctbl_Chc Enrlmt,
2415: Ben_Per_in_ler PIL,
2416: Ben_Pgm_F Pgm,
2417: Ben_PLip_F Plip,
2418: Ben_Pl_F Pl,

Line 2505: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;

2501: l_entries_changed_warning Varchar2(250);
2502: l_tax_district_changed_warning Boolean;
2503: l_concatenated_segments Varchar2(250);
2504: L_DATE_TRACK_MODE Varchar2(25);
2505: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;
2506: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;
2507: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;
2508: Begin
2509:

Line 2688: From ben_Elig_Per_Elctbl_Chc Elct,

2684:
2685: Cursor Elctbl is
2686: Select Elct.ELIG_PER_ELCTBL_CHC_ID, Pil.Person_Id, Pil.Per_In_Ler_id, Pil. Object_Version_Number,
2687: Elct.Enrt_Cvg_Strt_Dt, Pgm.Update_Salary_Cd, Pgm.Dflt_Step_Cd, Elct.Approval_Status_Cd, Person.Full_name
2688: From ben_Elig_Per_Elctbl_Chc Elct,
2689: Ben_Ler_F Ler,
2690: Ben_Per_in_ler Pil,
2691: Ben_Pgm_F PGM,
2692: Per_All_People_F Person

Line 2891: Update Ben_Elig_per_elctbl_Chc

2887: Open Enrt_Rt;
2888: Fetch Enrt_Rt into L_Enrt_Rt_Id, l_Enrt_ovn;
2889: Close Enrt_Rt;
2890:
2891: Update Ben_Elig_per_elctbl_Chc
2892: Set Approval_Status_Cd = 'PQH_GSP_A'
2893: ,Enrt_Cvg_Strt_Dt = P_Prog_Dt
2894: ,Comments = P_Comments
2895: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;

Line 2905: Update Ben_Elig_per_elctbl_Chc

2901: End If;
2902:
2903: Elsif P_Approve_Rej = 'PQH_GSP_R' Then
2904:
2905: Update Ben_Elig_per_elctbl_Chc
2906: Set Approval_Status_Cd = 'PQH_GSP_R'
2907: Where Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
2908:
2909: End If;

Line 3230: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

3226: l_Step_Exists Varchar2(1) := 'N';
3227: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
3228: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
3229: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3230: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3231: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3232: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3233: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3234: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 3231: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

3227: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
3228: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
3229: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3230: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3231: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3232: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3233: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3234: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3235: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;

Line 3233: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

3229: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3230: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3231: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3232: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3233: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3234: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3235: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3236: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3237: L_Elctbl_Flag Varchar2(1) := 'N';

Line 3234: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

3230: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3231: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3232: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3233: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3234: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3235: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3236: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3237: L_Elctbl_Flag Varchar2(1) := 'N';
3238: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

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

Line 3246: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%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;
3248: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
3249: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
3250: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;

Line 3499: from Ben_ELig_per_Elctbl_Chc

3495: */
3496: Cursor csr_elct_chcs
3497: is
3498: Select Elig_per_Elctbl_Chc_Id,COMP_LVL_CD,pgm_id
3499: from Ben_ELig_per_Elctbl_Chc
3500: where per_in_ler_id = p_per_in_ler_id;
3501:
3502: Cursor csr_pil_dtls
3503: IS

Line 3560: From Ben_ELig_per_Elctbl_Chc Enrt,

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

Line 3959: Update Ben_Elig_per_elctbl_Chc

3955: ,p_pgm_id => p_grade_ladder_id
3956: ,p_pl_id => p_pl_id
3957: );
3958:
3959: Update Ben_Elig_per_elctbl_Chc
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