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 PER_SPINAL_POINT_STEPS_F

Line 115: l_Step_id Per_Spinal_POint_Steps_F.Step_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;
119: l_Le_Exists Varchar2(1);

Line 172: Per_Spinal_point_Steps_F Step

168:
169: Cursor Step_Dtls Is
170: Select Plcmt.Step_id
171: From Per_Spinal_POint_Placements_f Plcmt,
172: Per_Spinal_point_Steps_F Step
173: Where Plcmt.Assignment_id = P_Assignment_Id
174: and P_Effective_Date
175: Between Plcmt.Effective_Start_Date
176: and plcmt.Effective_End_Date

Line 761: Per_Spinal_point_Steps_F Step

757:
758: Cursor Step_Dtls Is
759: Select Plcmt.Step_id, Step.Spinal_point_id, Plcmt.Effective_Start_Date
760: From Per_Spinal_POint_Placements_f Plcmt,
761: Per_Spinal_point_Steps_F Step
762: Where Plcmt.Assignment_id = P_Assignment_Id
763: and P_Effective_Date
764: Between Plcmt.Effective_Start_Date
765: and plcmt.Effective_End_Date

Line 920: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%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;
924: l_VOIDD_DT Date;

Line 2289: Per_Spinal_point_Steps_F Step

2285: Ben_pl_F Pl,
2286: Ben_Opt_F Opt,
2287: Per_Spinal_points point,
2288: Per_Grade_Spines_f GSpine,
2289: Per_Spinal_point_Steps_F Step
2290: Where Oipl.Oipl_id = P_Oipl_Id
2291: and P_Effective_Date
2292: Between OiPl.Effective_Start_Date and OiPl.Effective_End_Date
2293: and Pl.Pl_id = Oipl.Pl_Id

Line 2322: l_Step_Id Per_Spinal_point_Steps_F.Step_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;
2326: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;

Line 2323: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_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;
2326: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
2327: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;

Line 2324: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_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;
2326: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
2327: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
2328: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;

Line 2968: Per_Spinal_point_Steps_F Step

2964: Cursor Step_Dtls
2965: Is
2966: Select Plcmt.Step_id, Step.Spinal_point_id
2967: From Per_Spinal_POint_Placements_f Plcmt,
2968: Per_Spinal_point_Steps_F Step
2969: Where Plcmt.Assignment_id = P_Assignment_Id
2970: and P_Effective_Date
2971: Between Plcmt.Effective_Start_Date
2972: and plcmt.Effective_End_Date

Line 3061: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%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;
3065: l_VOIDD_DT Date;