APPS.PQH_GSP_POST_PROCESS dependencies on BEN_ACTY_BASE_RT_F

Line 816: From Ben_Acty_base_Rt_f

812: and pee.effective_end_date;
813:
814: Cursor Pl_Bas_rt(l_Pl_Id IN Number) Is
815: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
816: From Ben_Acty_base_Rt_f
817: where Pl_id = l_Pl_Id
818: and P_effective_Date
819: Between Effective_Start_Date
820: and Effective_End_Date;

Line 824: From Ben_Acty_Base_rt_f

820: and Effective_End_Date;
821:
822: Cursor Opt_Bas_Rt(l_Opt_Id IN Number) Is
823: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
824: From Ben_Acty_Base_rt_f
825: where Opt_Id = L_Opt_id
826: and P_effective_Date
827: Between Effective_Start_Date
828: and Effective_End_Date;

Line 947: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%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;
951: l_start_date ben_yr_perd.start_date%TYPE;

Line 3025: From Ben_Acty_base_Rt_f

3021: and pee.effective_end_date;
3022:
3023: Cursor Pl_Bas_rt(l_Pl_Id IN Number) Is
3024: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
3025: From Ben_Acty_base_Rt_f
3026: where Pl_id = l_Pl_Id
3027: and P_effective_Date
3028: Between Effective_Start_Date
3029: and Effective_End_Date;

Line 3033: From Ben_Acty_Base_rt_f

3029: and Effective_End_Date;
3030:
3031: Cursor Opt_Bas_Rt(l_Opt_Id IN Number) Is
3032: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
3033: From Ben_Acty_Base_rt_f
3034: where Opt_Id = L_Opt_id
3035: and P_effective_Date
3036: Between Effective_Start_Date
3037: and Effective_End_Date;

Line 3088: l_Entr_Ann_Val_Flag Ben_Acty_Base_rt_F.Entr_Ann_Val_Flag%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;
3092: l_start_date ben_yr_perd.start_date%TYPE;