APPS.PQH_GSP_POST_PROCESS dependencies on BEN_YR_PERD

Line 938: ben_yr_perd yp

934: pyp.popl_yr_perd_id,
935: yp.start_date,
936: yp.end_date
937: FROM ben_popl_yr_perd pyp,
938: ben_yr_perd yp
939: WHERE pyp.pl_id = P_Pl_Id
940: AND pyp.yr_perd_id = yp.yr_perd_id
941: AND pyp.business_group_id = P_Bg_Id
942: AND P_Effective_Date

Line 948: From Ben_Yr_Perd

944: AND yp.business_group_id = P_Bg_Id; */
945:
946: Cursor Yr_Prd is
947: Select Yr_Perd_id
948: From Ben_Yr_Perd
949: Where P_Effective_Date
950: Between Start_Date and End_Date;
951:
952: Cursor Dflt_GrdLdr is

Line 1052: l_start_date ben_yr_perd.start_date%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;
1054: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1055: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
1056: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

Line 1053: l_end_date ben_yr_perd.end_date%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;
1054: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1055: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
1056: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
1057: l_New_Enrlmt_Dt Date;

Line 3201: From Ben_Yr_Perd

3197: and Effective_End_Date;
3198:
3199: Cursor Yr_Prd is
3200: Select Yr_Perd_id
3201: From Ben_Yr_Perd
3202: Where P_Effective_Date
3203: Between Start_Date and End_Date;
3204:
3205: Cursor Dflt_GrdLdr is

Line 3252: l_start_date ben_yr_perd.start_date%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;
3254: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3255: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3256: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

Line 3253: l_end_date ben_yr_perd.end_date%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;
3254: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3255: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3256: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3257: