APPS.PQH_GSP_POST_PROCESS dependencies on PER_GRADES

Line 158: and Plan.Mapping_Table_name = 'PER_GRADES'

154: and P_effective_date
155: Between Pgm.Effective_Start_Date
156: and Pgm.Effective_End_Date
157: and Pgm.Business_Group_id = hr_general.get_Business_group_Id
158: and Plan.Mapping_Table_name = 'PER_GRADES'
159: and Plan.Mapping_Table_Pk_id = l_grade_Id
160: and P_Effective_Date
161: Between Plan.Effective_Start_Date
162: and Plan.Effective_End_Date

Line 788: and Pl.Mapping_table_Name = 'PER_GRADES'

784: Where Pgm.Pgm_Id = P_Pgm_Id
785: and P_Effective_Date
786: Between Pgm.Effective_Start_Date
787: and Pgm.Effective_End_Date
788: and Pl.Mapping_table_Name = 'PER_GRADES'
789: and Pl.Mapping_Table_Pk_Id = P_Grd_Id
790: and P_Effective_Date
791: Between Pl.Effective_Start_Date
792: and Pl.Effective_End_Date

Line 1019: l_Grade_Id Per_Grades.Grade_Id%TYPE;

1015: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_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;

Line 2481: l_Grade_Id Per_Grades.Grade_Id%TYPE;

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;
2485: l_Assignment_id Per_All_Assignments_F.Assignment_Id%TYPE;

Line 2958: and pl.mapping_table_name = 'PER_GRADES'

2954: and pltyp.opt_typ_cd = 'GSP'
2955: and p_effective_date between pltyp.effective_start_date and pltyp.effective_end_date
2956: and pl.pl_typ_id = pltyp.pl_typ_id
2957: and pl.business_group_id = p_business_group_id
2958: and pl.mapping_table_name = 'PER_GRADES'
2959: and pl.mapping_table_pk_id = p_grade_id
2960: and p_effective_date between pl.effective_start_date and pl.effective_end_date
2961: and pl.pl_stat_cd = 'A';
2962: --

Line 3113: and Pl.Mapping_table_Name = 'PER_GRADES'

3109: Where Pgm.Pgm_Id = P_Pgm_Id
3110: and P_Effective_Date
3111: Between Pgm.Effective_Start_Date
3112: and Pgm.Effective_End_Date
3113: and Pl.Mapping_table_Name = 'PER_GRADES'
3114: and Pl.Mapping_Table_Pk_Id = P_Grd_Id
3115: and P_Effective_Date
3116: Between Pl.Effective_Start_Date
3117: and Pl.Effective_End_Date

Line 3219: l_Grade_Id Per_Grades.Grade_Id%TYPE;

3215: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_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;