DBA Data[Home] [Help]

APPS.PQH_GSP_POST_PROCESS dependencies on BEN_POPL_YR_PERD

Line 885: FROM ben_popl_yr_perd pyp,

881: SELECT pyp.yr_perd_id,
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

Line 949: l_yr_perd_id ben_popl_yr_perd.yr_perd_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;
952: l_end_date ben_yr_perd.end_date%TYPE;
953: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

Line 950: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%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;
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;

Line 3090: l_yr_perd_id ben_popl_yr_perd.yr_perd_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;
3093: l_end_date ben_yr_perd.end_date%TYPE;
3094: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

Line 3091: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%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;
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;