[Home] [Help]
813: P_Point_id In Number) Is
814: Select Oipl.Oipl_Id, Opt.Opt_Id
815: From Ben_Opt_F Opt,
816: Ben_Oipl_F Oipl
817: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
818: and Opt.mapping_table_Pk_Id = P_Point_id
819: and P_Effective_Date
820: Between Opt.Effective_Start_Date
821: and Opt.Effective_End_Date
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;
1026: l_Step_Exists Varchar2(1) := 'N';
2443: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
2444: From Ben_Oipl_F Oipl,
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
3139: P_Point_id In Number) Is
3140: Select Oipl.Oipl_Id, Opt.Opt_Id
3141: From Ben_Opt_F Opt,
3142: Ben_Oipl_F Oipl
3143: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
3144: and Opt.mapping_table_Pk_Id = P_Point_id
3145: and P_Effective_Date
3146: Between Opt.Effective_Start_Date
3147: and Opt.Effective_End_Date
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;
3226: l_Step_Exists Varchar2(1) := 'N';