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 435: from Ben_Pgm_F

431: and Pler.Per_In_Ler_Id = Elct.Per_In_Ler_Id;
432:
433: Cursor Pgm_Dtl(P_Pgm_Id In Number) Is
434: Select Update_Salary_Cd
435: from Ben_Pgm_F
436: where Pgm_Id = P_Pgm_Id
437: and P_Effective_Date
438: Between Effective_Start_Date
439: and Effective_End_Date;

Line 443: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

439: and Effective_End_Date;
440:
441: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
442: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
443: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
444: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
445: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;
446:
447: l_PROCD_DT DATE;

Line 444: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

440:
441: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
442: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
443: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
444: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
445: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;
446:
447: l_PROCD_DT DATE;
448: l_STRTD_DT DATE;

Line 576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;

572: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
573: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
574: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
575: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
577: L_DATE_TRACK_MODE Varchar2(25);
578: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
579: l_group_name Varchar2(250);
580: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;

Line 781: from Ben_Pgm_F Pgm,

777:
778: Cursor Ben_Grd_Dtls(P_Pgm_Id In Number, P_Grd_Id In Number) Is
779: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
780: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
781: from Ben_Pgm_F Pgm,
782: Ben_Pl_F Pl,
783: Ben_Plip_f Plip
784: Where Pgm.Pgm_Id = P_Pgm_Id
785: and P_Effective_Date

Line 954: From Ben_PGM_F

950: Between Start_Date and End_Date;
951:
952: Cursor Dflt_GrdLdr is
953: Select Pgm_Id
954: From Ben_PGM_F
955: Where DFLT_PGM_FLAG = 'Y'
956: and Pgm_Typ_Cd = 'GSP'
957: and P_Effective_Date
958: Between Effective_Start_Date

Line 1020: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

1016: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
1017: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
1018: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;
1019: l_Grade_Id Per_Grades.Grade_Id%TYPE;
1020: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
1021: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
1022: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;
1023: l_PROCD_DT DATE;
1024: l_STRTD_DT DATE;

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

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

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

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

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

Line 1609: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%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;
1612: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1613: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

Line 1610: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%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;
1612: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1613: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1614: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

Line 1611: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%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;
1612: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1613: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1614: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1615: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;

Line 1627: From ben_Pgm_F

1623: l_payroll_warning boolean;
1624: --
1625: Cursor Pgm_Dtl(P_Pgm_Id In Number,P_effective_Date in date) is
1626: Select Update_Salary_Cd, DFLT_INPUT_VALUE_ID, DFLT_ELEMENT_TYPE_ID, DFLT_STEP_CD
1627: From ben_Pgm_F
1628: Where Pgm_id = P_Pgm_Id
1629: and P_effective_Date
1630: Between Effective_Start_Date
1631: and Effective_End_Date;

Line 1951: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

1947: L_APPROVED_WARNING Boolean;
1948: L_PAYROLL_WARNING Boolean;
1949: l_Del_Warn Boolean;
1950: L_ERROR_TEXT Varchar2(250);
1951: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1952: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1953: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1954: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1955: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

Line 1952: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;

1948: L_PAYROLL_WARNING Boolean;
1949: l_Del_Warn Boolean;
1950: L_ERROR_TEXT Varchar2(250);
1951: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1952: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1953: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1954: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1955: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
1956: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;

Line 1953: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;

1949: l_Del_Warn Boolean;
1950: L_ERROR_TEXT Varchar2(250);
1951: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1952: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1953: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1954: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1955: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
1956: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
1957: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;

Line 1960: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

1956: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
1957: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1958: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1959: l_Create_Warn Boolean;
1960: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1961: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
1962: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1963: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1964:

Line 2003: From ben_Pgm_F

1999: and ele.element_entry_id = entval.element_entry_id;
2000:
2001: Cursor Pgm_Dtl(P_Pgm_Id In Number,P_effective_Date in date) is
2002: Select Update_Salary_Cd, DFLT_INPUT_VALUE_ID, DFLT_ELEMENT_TYPE_ID, DFLT_STEP_CD
2003: From ben_Pgm_F
2004: Where Pgm_id = P_Pgm_Id
2005: and P_effective_Date
2006: Between Effective_Start_Date
2007: and Effective_End_Date;

Line 2416: Ben_Pgm_F Pgm,

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

Line 2478: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

2474: Between Effective_Start_Date
2475: and Effective_End_Date;
2476:
2477: L_PL_Id Ben_Pl_F.Pl_Id%TYPE;
2478: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
2479: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
2480: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
2481: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2482: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;

Line 2480: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

2476:
2477: L_PL_Id Ben_Pl_F.Pl_Id%TYPE;
2478: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
2479: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
2480: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
2481: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2482: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2483: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2484: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;

Line 2662: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;

2658: L_APPROVED_WARNING Boolean;
2659: L_PAYROLL_WARNING Boolean;
2660: l_Error_Message Varchar2(250);
2661: L_Concurrent_Req_Id Number(18);
2662: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;
2663:
2664: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
2665: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
2666: l_PROCD_DT DATE;

Line 2691: Ben_Pgm_F PGM,

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
2693: where Ler.typ_Cd = 'GSP'
2694: and L_Effective_Date
2695: Between Ler.Effective_Start_Date

Line 2937: From ben_pgm_f

2933: and p_effective_date between effective_start_date and effective_end_date;
2934: --
2935: Cursor csr_get_default_gl is
2936: Select pgm_id,dflt_step_cd
2937: From ben_pgm_f
2938: Where business_group_id = p_business_group_id
2939: and pgm_typ_cd = 'GSP'
2940: and pgm_stat_cd = 'A'
2941: and nvl(dflt_pgm_flag,'N') = 'Y'

Line 2946: From ben_pgm_f

2942: and p_effective_date between effective_start_date and effective_end_date;
2943: --
2944: Cursor csr_pgm_details(p_pgm_id in number) is
2945: Select dflt_step_cd
2946: From ben_pgm_f
2947: Where pgm_id = p_pgm_id
2948: and p_effective_date between effective_start_date and effective_end_date;
2949: --
2950: Cursor csr_grade_pl(p_grade_id in number) is

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

2970:
2971: --
2972: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2973: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2974: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2975: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2976: l_grade_pl ben_pl_f.pl_id%type := NULL;
2977: l_grade_plip ben_plip_f.plip_id%type := NULL;
2978: --

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

2971: --
2972: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2973: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2974: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2975: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2976: l_grade_pl ben_pl_f.pl_id%type := NULL;
2977: l_grade_plip ben_plip_f.plip_id%type := NULL;
2978: --
2979: Begin

Line 3106: from Ben_Pgm_F Pgm,

3102:
3103: Cursor Ben_Grd_Dtls(P_Pgm_Id In Number, P_Grd_Id In Number) Is
3104: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
3105: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
3106: from Ben_Pgm_F Pgm,
3107: Ben_Pl_F Pl,
3108: Ben_Plip_f Plip
3109: Where Pgm.Pgm_Id = P_Pgm_Id
3110: and P_Effective_Date

Line 3207: From Ben_PGM_F

3203: Between Start_Date and End_Date;
3204:
3205: Cursor Dflt_GrdLdr is
3206: Select Pgm_Id
3207: From Ben_PGM_F
3208: Where DFLT_PGM_FLAG = 'Y'
3209: and Pgm_Typ_Cd = 'GSP'
3210: and P_Effective_Date
3211: Between Effective_Start_Date

Line 3220: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

3216: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3217: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3218: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3219: l_Grade_Id Per_Grades.Grade_Id%TYPE;
3220: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
3221: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
3222: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;
3223: l_PROCD_DT DATE;
3224: l_STRTD_DT DATE;

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

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

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

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

Line 3530: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

3526: l_salary_change_date date;
3527: L_PAYROLL_WARNING Boolean;
3528: l_Del_Warn Boolean;
3529: L_ERROR_TEXT Varchar2(250);
3530: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3531: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3532: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3533: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3534: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

Line 3531: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;

3527: L_PAYROLL_WARNING Boolean;
3528: l_Del_Warn Boolean;
3529: L_ERROR_TEXT Varchar2(250);
3530: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3531: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3532: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3533: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3534: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
3535: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;

Line 3532: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;

3528: l_Del_Warn Boolean;
3529: L_ERROR_TEXT Varchar2(250);
3530: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3531: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3532: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3533: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3534: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
3535: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
3536: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;

Line 3539: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

3535: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
3536: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
3537: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
3538: l_Create_Warn Boolean;
3539: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3540: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
3541: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
3542: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3543: l_cur_sal number;

Line 3550: l_ACTY_REF_PERD_CD ben_pgm_f.ACTY_REF_PERD_CD%TYPE;

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

Line 3591: From ben_Pgm_F

3587: and ele.element_entry_id = entval.element_entry_id;
3588:
3589: Cursor Pgm_Dtl(P_Pgm_Id In Number) is
3590: Select Update_Salary_Cd, DFLT_INPUT_VALUE_ID, DFLT_ELEMENT_TYPE_ID, DFLT_STEP_CD,ACTY_REF_PERD_CD
3591: From ben_Pgm_F
3592: Where Pgm_id = P_Pgm_Id
3593: and P_effective_Date
3594: Between Effective_Start_Date
3595: and Effective_End_Date;