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_PGM_F

Line 106: l_Pgm_Id BEN_PGM_F.Pgm_Id%TYPE;

102: P_Assignment_Id IN Number,
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;

Line 108: l_Update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

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;
112: L_Cnt Number;

Line 114: l_Dflt_Step_Cd Ben_Pgm_F.Dflt_Step_Cd%TYPE;

110: l_Person_Id Per_All_People_F.Person_Id%TYPE;
111: l_Last_Name Per_All_People_F.Last_name%TYPE;
112: L_Cnt Number;
113: l_Grade_id Per_all_Assignments_F.Grade_Id%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;

Line 141: from Ben_Pgm_F

137: and Person.Effective_End_Date;
138:
139: Cursor Dflt_Step Is
140: Select Dflt_Step_cd, Update_Salary_Cd
141: from Ben_Pgm_F
142: Where Pgm_id = l_Pgm_Id
143: and P_Effective_Date
144: Between Effective_Start_Date
145: and Effective_End_Date;

Line 149: From Ben_Pgm_F Pgm,

145: and Effective_End_Date;
146:
147: Cursor Dflt_grdldr is
148: Select Pgm.Pgm_Id
149: From Ben_Pgm_F Pgm,
150: Ben_Plip_F Plip,
151: Ben_Pl_F Plan
152: where Pgm.Dflt_Pgm_Flag = 'Y'
153: and Pgm.Pgm_Typ_Cd = 'GSP'

Line 394: from Ben_Pgm_F

390: and Pler.Per_In_Ler_Id = Elct.Per_In_Ler_Id;
391:
392: Cursor Pgm_Dtl(P_Pgm_Id In Number) Is
393: Select Update_Salary_Cd
394: from Ben_Pgm_F
395: where Pgm_Id = P_Pgm_Id
396: and P_Effective_Date
397: Between Effective_Start_Date
398: and Effective_End_Date;

Line 402: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

398: and Effective_End_Date;
399:
400: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
401: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
402: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
403: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
404: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;
405:
406: l_PROCD_DT DATE;

Line 403: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

399:
400: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
401: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
402: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
403: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
404: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;
405:
406: l_PROCD_DT DATE;
407: l_STRTD_DT DATE;

Line 535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;

531: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
532: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
533: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
534: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
536: L_DATE_TRACK_MODE Varchar2(25);
537: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
538: l_group_name Varchar2(250);
539: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;

Line 740: from Ben_Pgm_F Pgm,

736:
737: Cursor Ben_Grd_Dtls(P_Pgm_Id In Number, P_Grd_Id In Number) Is
738: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
739: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
740: from Ben_Pgm_F Pgm,
741: Ben_Pl_F Pl,
742: Ben_Plip_f Plip
743: Where Pgm.Pgm_Id = P_Pgm_Id
744: and P_Effective_Date

Line 902: From Ben_PGM_F

898: Between Start_Date and End_Date;
899:
900: Cursor Dflt_GrdLdr is
901: Select Pgm_Id
902: From Ben_PGM_F
903: Where DFLT_PGM_FLAG = 'Y'
904: and Pgm_Typ_Cd = 'GSP'
905: and P_Effective_Date
906: Between Effective_Start_Date

Line 919: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

915: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
916: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
917: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;
918: l_Grade_Id Per_Grades.Grade_Id%TYPE;
919: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
920: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
921: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;
922: l_PROCD_DT DATE;
923: l_STRTD_DT DATE;

Line 934: l_Prog_style Ben_Pgm_F.Enrt_Cd%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;
938: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

Line 935: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%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;
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;

Line 937: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%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;
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;

Line 939: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%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;
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;

Line 1448: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%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;
1452: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;

Line 1449: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%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;
1452: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1453: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

Line 1450: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%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;
1452: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1453: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1454: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

Line 1451: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%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;
1452: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1453: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1454: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1455: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;

Line 1467: From ben_Pgm_F

1463: l_payroll_warning boolean;
1464: --
1465: Cursor Pgm_Dtl(P_Pgm_Id In Number,P_effective_Date in date) is
1466: Select Update_Salary_Cd, DFLT_INPUT_VALUE_ID, DFLT_ELEMENT_TYPE_ID, DFLT_STEP_CD
1467: From ben_Pgm_F
1468: Where Pgm_id = P_Pgm_Id
1469: and P_effective_Date
1470: Between Effective_Start_Date
1471: and Effective_End_Date;

Line 1791: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

1787: L_APPROVED_WARNING Boolean;
1788: L_PAYROLL_WARNING Boolean;
1789: l_Del_Warn Boolean;
1790: L_ERROR_TEXT Varchar2(250);
1791: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1792: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1793: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1794: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1795: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

Line 1792: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;

1788: L_PAYROLL_WARNING Boolean;
1789: l_Del_Warn Boolean;
1790: L_ERROR_TEXT Varchar2(250);
1791: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1792: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1793: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1794: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1795: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
1796: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;

Line 1793: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;

1789: l_Del_Warn Boolean;
1790: L_ERROR_TEXT Varchar2(250);
1791: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1792: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1793: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1794: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1795: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
1796: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
1797: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;

Line 1800: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

1796: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
1797: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1798: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1799: l_Create_Warn Boolean;
1800: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1801: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
1802: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1803: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1804:

Line 1843: From ben_Pgm_F

1839: and ele.element_entry_id = entval.element_entry_id;
1840:
1841: Cursor Pgm_Dtl(P_Pgm_Id In Number,P_effective_Date in date) is
1842: Select Update_Salary_Cd, DFLT_INPUT_VALUE_ID, DFLT_ELEMENT_TYPE_ID, DFLT_STEP_CD
1843: From ben_Pgm_F
1844: Where Pgm_id = P_Pgm_Id
1845: and P_effective_Date
1846: Between Effective_Start_Date
1847: and Effective_End_Date;

Line 2256: Ben_Pgm_F Pgm,

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,
2259: Per_All_Assignments_F Asgt
2260: Where Enrlmt.Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_Id

Line 2318: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

2314: Between Effective_Start_Date
2315: and Effective_End_Date;
2316:
2317: L_PL_Id Ben_Pl_F.Pl_Id%TYPE;
2318: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
2319: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
2320: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
2321: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2322: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;

Line 2320: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

2316:
2317: L_PL_Id Ben_Pl_F.Pl_Id%TYPE;
2318: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
2319: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
2320: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
2321: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2322: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2323: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2324: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;

Line 2502: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;

2498: L_APPROVED_WARNING Boolean;
2499: L_PAYROLL_WARNING Boolean;
2500: l_Error_Message Varchar2(250);
2501: L_Concurrent_Req_Id Number(18);
2502: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;
2503:
2504: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
2505: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
2506: l_PROCD_DT DATE;

Line 2531: Ben_Pgm_F PGM,

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
2533: where Ler.typ_Cd = 'GSP'
2534: and L_Effective_Date
2535: Between Ler.Effective_Start_Date

Line 2777: From ben_pgm_f

2773: and p_effective_date between effective_start_date and effective_end_date;
2774: --
2775: Cursor csr_get_default_gl is
2776: Select pgm_id,dflt_step_cd
2777: From ben_pgm_f
2778: Where business_group_id = p_business_group_id
2779: and pgm_typ_cd = 'GSP'
2780: and pgm_stat_cd = 'A'
2781: and nvl(dflt_pgm_flag,'N') = 'Y'

Line 2786: From ben_pgm_f

2782: and p_effective_date between effective_start_date and effective_end_date;
2783: --
2784: Cursor csr_pgm_details(p_pgm_id in number) is
2785: Select dflt_step_cd
2786: From ben_pgm_f
2787: Where pgm_id = p_pgm_id
2788: and p_effective_date between effective_start_date and effective_end_date;
2789: --
2790: Cursor csr_grade_pl(p_grade_id in number) is

Line 2814: l_def_gl ben_pgm_f.pgm_id%type := NULL;

2810:
2811: --
2812: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2813: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2814: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2815: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2816: l_grade_pl ben_pl_f.pl_id%type := NULL;
2817: l_grade_plip ben_plip_f.plip_id%type := NULL;
2818: --

Line 2815: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;

2811: --
2812: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2813: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2814: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2815: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2816: l_grade_pl ben_pl_f.pl_id%type := NULL;
2817: l_grade_plip ben_plip_f.plip_id%type := NULL;
2818: --
2819: Begin

Line 2946: from Ben_Pgm_F Pgm,

2942:
2943: Cursor Ben_Grd_Dtls(P_Pgm_Id In Number, P_Grd_Id In Number) Is
2944: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
2945: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
2946: from Ben_Pgm_F Pgm,
2947: Ben_Pl_F Pl,
2948: Ben_Plip_f Plip
2949: Where Pgm.Pgm_Id = P_Pgm_Id
2950: and P_Effective_Date

Line 3047: From Ben_PGM_F

3043: Between Start_Date and End_Date;
3044:
3045: Cursor Dflt_GrdLdr is
3046: Select Pgm_Id
3047: From Ben_PGM_F
3048: Where DFLT_PGM_FLAG = 'Y'
3049: and Pgm_Typ_Cd = 'GSP'
3050: and P_Effective_Date
3051: Between Effective_Start_Date

Line 3060: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

3056: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3057: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3058: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3059: l_Grade_Id Per_Grades.Grade_Id%TYPE;
3060: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
3061: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
3062: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;
3063: l_PROCD_DT DATE;
3064: l_STRTD_DT DATE;

Line 3075: l_Prog_style Ben_Pgm_F.Enrt_Cd%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;
3079: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

Line 3076: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%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;
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;

Line 3078: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%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;
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;

Line 3080: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%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;
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;

Line 3370: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

3366: l_salary_change_date date;
3367: L_PAYROLL_WARNING Boolean;
3368: l_Del_Warn Boolean;
3369: L_ERROR_TEXT Varchar2(250);
3370: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3371: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3372: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3373: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3374: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

Line 3371: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;

3367: L_PAYROLL_WARNING Boolean;
3368: l_Del_Warn Boolean;
3369: L_ERROR_TEXT Varchar2(250);
3370: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3371: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3372: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3373: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3374: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
3375: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;

Line 3372: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;

3368: l_Del_Warn Boolean;
3369: L_ERROR_TEXT Varchar2(250);
3370: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3371: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3372: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3373: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3374: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
3375: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
3376: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;

Line 3379: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

3375: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
3376: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
3377: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
3378: l_Create_Warn Boolean;
3379: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3380: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
3381: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
3382: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3383: l_cur_sal number;

Line 3390: l_ACTY_REF_PERD_CD ben_pgm_f.ACTY_REF_PERD_CD%TYPE;

3386: l_strtd_date date;
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;

Line 3431: From ben_Pgm_F

3427: and ele.element_entry_id = entval.element_entry_id;
3428:
3429: Cursor Pgm_Dtl(P_Pgm_Id In Number) is
3430: Select Update_Salary_Cd, DFLT_INPUT_VALUE_ID, DFLT_ELEMENT_TYPE_ID, DFLT_STEP_CD,ACTY_REF_PERD_CD
3431: From ben_Pgm_F
3432: Where Pgm_id = P_Pgm_Id
3433: and P_effective_Date
3434: Between Effective_Start_Date
3435: and Effective_End_Date;