APPS.PQH_GSP_POST_PROCESS dependencies on BEN_LEE_RSN_F

Line 874: Ben_Lee_Rsn_f Lrsn

870:
871: Cursor Lee_Rsn(P_Pgm_Id IN Number) is
872: Select Lrsn.Lee_Rsn_Id
873: From Ben_Popl_Enrt_Typ_Cycl_F Cylc,
874: Ben_Lee_Rsn_f Lrsn
875: Where Cylc.ENRT_TYP_CYCL_CD = 'L'
876: and Cylc.Pgm_Id = P_Pgm_Id
877: and P_Effective_Date
878: Between Cylc.Effective_Start_Date

Line 1049: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_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;
1052: l_start_date ben_yr_perd.start_date%TYPE;
1053: l_end_date ben_yr_perd.end_date%TYPE;

Line 3249: L_Lee_Rsn_Id Ben_Lee_Rsn_f.Lee_Rsn_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;
3252: l_start_date ben_yr_perd.start_date%TYPE;
3253: l_end_date ben_yr_perd.end_date%TYPE;