[Home] [Help]
770:
771: Cursor Ben_Dtls(P_Pl_id In Number,
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
942: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
943: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
944: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
945: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
946: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;
947: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
948: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
949: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
950: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;
2282: Cursor Step_Dtls(P_Oipl_Id IN NUmber) Is
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
2977:
2978: Cursor Ben_Dtls(P_Pl_id In Number,
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
3083: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3084: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3085: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
3086: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3087: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;
3088: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
3089: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
3090: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
3091: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;