APPS.PQH_GSP_POST_PROCESS dependencies on BEN_LEE_RSN_F

Line 833: Ben_Lee_Rsn_f Lrsn

829:
830: Cursor Lee_Rsn(P_Pgm_Id IN Number) is
831: Select Lrsn.Lee_Rsn_Id
832: From Ben_Popl_Enrt_Typ_Cycl_F Cylc,
833: Ben_Lee_Rsn_f Lrsn
834: Where Cylc.ENRT_TYP_CYCL_CD = 'L'
835: and Cylc.Pgm_Id = P_Pgm_Id
836: and P_Effective_Date
837: Between Cylc.Effective_Start_Date

Line 948: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_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;
951: l_start_date ben_yr_perd.start_date%TYPE;
952: l_end_date ben_yr_perd.end_date%TYPE;

Line 3089: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_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;
3092: l_start_date ben_yr_perd.start_date%TYPE;
3093: l_end_date ben_yr_perd.end_date%TYPE;