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 802: Per_Spinal_point_Steps_F Step

798:
799: Cursor Step_Dtls Is
800: Select Plcmt.Step_id, Step.Spinal_point_id, Plcmt.Effective_Start_Date
801: From Per_Spinal_POint_Placements_f Plcmt,
802: Per_Spinal_point_Steps_F Step
803: Where Plcmt.Assignment_id = P_Assignment_Id
804: and P_Effective_Date
805: Between Plcmt.Effective_Start_Date
806: and plcmt.Effective_End_Date

Line 974: FROM per_spinal_point_steps_f steps

970:
971: AND grd.grade_or_spinal_point_id IN
972: (
973: SELECT steps.spinal_point_id
974: FROM per_spinal_point_steps_f steps
975: WHERE p_effective_date between steps.effective_start_date AND steps.effective_end_date
976:
977: AND steps.step_id IN
978: (

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

Line 2449: Per_Spinal_point_Steps_F Step

2445: Ben_pl_F Pl,
2446: Ben_Opt_F Opt,
2447: Per_Spinal_points point,
2448: Per_Grade_Spines_f GSpine,
2449: Per_Spinal_point_Steps_F Step
2450: Where Oipl.Oipl_id = P_Oipl_Id
2451: and P_Effective_Date
2452: Between OiPl.Effective_Start_Date and OiPl.Effective_End_Date
2453: and Pl.Pl_id = Oipl.Pl_Id

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

Line 2483: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_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;
2486: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
2487: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;

Line 2484: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_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;
2486: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
2487: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
2488: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;

Line 3128: Per_Spinal_point_Steps_F Step

3124: Cursor Step_Dtls
3125: Is
3126: Select Plcmt.Step_id, Step.Spinal_point_id
3127: From Per_Spinal_POint_Placements_f Plcmt,
3128: Per_Spinal_point_Steps_F Step
3129: Where Plcmt.Assignment_id = P_Assignment_Id
3130: and P_Effective_Date
3131: Between Plcmt.Effective_Start_Date
3132: and plcmt.Effective_End_Date

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