[Home] [Help]
772: P_Point_id In Number) Is
773: Select Oipl.Oipl_Id, Opt.Opt_Id
774: From Ben_Opt_F Opt,
775: Ben_Oipl_F Oipl
776: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
777: and Opt.mapping_table_Pk_Id = P_Point_id
778: and P_Effective_Date
779: Between Opt.Effective_Start_Date
780: and Opt.Effective_End_Date
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;
925: l_Step_Exists Varchar2(1) := 'N';
2283: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
2284: From Ben_Oipl_F Oipl,
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
2979: P_Point_id In Number) Is
2980: Select Oipl.Oipl_Id, Opt.Opt_Id
2981: From Ben_Opt_F Opt,
2982: Ben_Oipl_F Oipl
2983: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
2984: and Opt.mapping_table_Pk_Id = P_Point_id
2985: and P_Effective_Date
2986: Between Opt.Effective_Start_Date
2987: and Opt.Effective_End_Date
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;
3066: l_Step_Exists Varchar2(1) := 'N';