APPS.PQH_GSP_POST_PROCESS dependencies on BEN_YR_PERD

Line 886: ben_yr_perd yp

882: pyp.popl_yr_perd_id,
883: yp.start_date,
884: yp.end_date
885: FROM ben_popl_yr_perd pyp,
886: ben_yr_perd yp
887: WHERE pyp.pl_id = P_Pl_Id
888: AND pyp.yr_perd_id = yp.yr_perd_id
889: AND pyp.business_group_id = P_Bg_Id
890: AND P_Effective_Date

Line 896: From Ben_Yr_Perd

892: AND yp.business_group_id = P_Bg_Id; */
893:
894: Cursor Yr_Prd is
895: Select Yr_Perd_id
896: From Ben_Yr_Perd
897: Where P_Effective_Date
898: Between Start_Date and End_Date;
899:
900: Cursor Dflt_GrdLdr is

Line 951: l_start_date ben_yr_perd.start_date%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;
953: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
954: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
955: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

Line 952: l_end_date ben_yr_perd.end_date%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;
953: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
954: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
955: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
956: l_New_Enrlmt_Dt Date;

Line 3041: From Ben_Yr_Perd

3037: and Effective_End_Date;
3038:
3039: Cursor Yr_Prd is
3040: Select Yr_Perd_id
3041: From Ben_Yr_Perd
3042: Where P_Effective_Date
3043: Between Start_Date and End_Date;
3044:
3045: Cursor Dflt_GrdLdr is

Line 3092: l_start_date ben_yr_perd.start_date%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;
3094: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3095: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3096: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

Line 3093: l_end_date ben_yr_perd.end_date%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;
3094: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3095: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3096: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3097: