APPS.PQH_GSP_POST_PROCESS dependencies on BEN_ACTY_BASE_RT_F

Line 857: From Ben_Acty_base_Rt_f

853: and pee.effective_end_date;
854:
855: Cursor Pl_Bas_rt(l_Pl_Id IN Number) Is
856: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
857: From Ben_Acty_base_Rt_f
858: where Pl_id = l_Pl_Id
859: and P_effective_Date
860: Between Effective_Start_Date
861: and Effective_End_Date;

Line 865: From Ben_Acty_Base_rt_f

861: and Effective_End_Date;
862:
863: Cursor Opt_Bas_Rt(l_Opt_Id IN Number) Is
864: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
865: From Ben_Acty_Base_rt_f
866: where Opt_Id = L_Opt_id
867: and P_effective_Date
868: Between Effective_Start_Date
869: and Effective_End_Date;

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

Line 3185: From Ben_Acty_base_Rt_f

3181: and pee.effective_end_date;
3182:
3183: Cursor Pl_Bas_rt(l_Pl_Id IN Number) Is
3184: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
3185: From Ben_Acty_base_Rt_f
3186: where Pl_id = l_Pl_Id
3187: and P_effective_Date
3188: Between Effective_Start_Date
3189: and Effective_End_Date;

Line 3193: From Ben_Acty_Base_rt_f

3189: and Effective_End_Date;
3190:
3191: Cursor Opt_Bas_Rt(l_Opt_Id IN Number) Is
3192: Select ACTY_BASE_RT_ID, Rt_Typ_cd, Entr_Ann_Val_Flag
3193: From Ben_Acty_Base_rt_f
3194: where Opt_Id = L_Opt_id
3195: and P_effective_Date
3196: Between Effective_Start_Date
3197: and Effective_End_Date;

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