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 747: and Pl.Mapping_table_Name = 'PER_GRADES'

743: Where Pgm.Pgm_Id = P_Pgm_Id
744: and P_Effective_Date
745: Between Pgm.Effective_Start_Date
746: and Pgm.Effective_End_Date
747: and Pl.Mapping_table_Name = 'PER_GRADES'
748: and Pl.Mapping_Table_Pk_Id = P_Grd_Id
749: and P_Effective_Date
750: Between Pl.Effective_Start_Date
751: and Pl.Effective_End_Date

Line 918: l_Grade_Id Per_Grades.Grade_Id%TYPE;

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

Line 2321: l_Grade_Id Per_Grades.Grade_Id%TYPE;

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

Line 2798: and pl.mapping_table_name = 'PER_GRADES'

2794: and pltyp.opt_typ_cd = 'GSP'
2795: and p_effective_date between pltyp.effective_start_date and pltyp.effective_end_date
2796: and pl.pl_typ_id = pltyp.pl_typ_id
2797: and pl.business_group_id = p_business_group_id
2798: and pl.mapping_table_name = 'PER_GRADES'
2799: and pl.mapping_table_pk_id = p_grade_id
2800: and p_effective_date between pl.effective_start_date and pl.effective_end_date
2801: and pl.pl_stat_cd = 'A';
2802: --

Line 2953: and Pl.Mapping_table_Name = 'PER_GRADES'

2949: Where Pgm.Pgm_Id = P_Pgm_Id
2950: and P_Effective_Date
2951: Between Pgm.Effective_Start_Date
2952: and Pgm.Effective_End_Date
2953: and Pl.Mapping_table_Name = 'PER_GRADES'
2954: and Pl.Mapping_Table_Pk_Id = P_Grd_Id
2955: and P_Effective_Date
2956: Between Pl.Effective_Start_Date
2957: and Pl.Effective_End_Date

Line 3059: l_Grade_Id Per_Grades.Grade_Id%TYPE;

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