[Home] [Help]
811:
812: Cursor Ben_Dtls(P_Pl_id In Number,
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
1043: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
1044: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1045: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
1046: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1047: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;
1048: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
1049: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
1050: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
1051: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;
2442: Cursor Step_Dtls(P_Oipl_Id IN NUmber) Is
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
3137:
3138: Cursor Ben_Dtls(P_Pl_id In Number,
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
3243: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;
3244: L_Rt_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3245: L_Acty_Base_rt_Id Ben_Acty_Base_Rt.Acty_Base_rt_Id%TYPE;
3246: l_Enrt_Rt_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3247: l_Opt_id Ben_Opt_F.Opt_Id%TYPE;
3248: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%TYPE;
3249: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_Id%TYPE;
3250: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
3251: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;