APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_YR_PERD

Line 2047: -- p_start_date is set to ben_yr_perd.start_date

2043: -- To get what sets what, refer to the following logic.
2044: --
2045: -- Priority 1:
2046: -- p_complete_year_flag = 'Y'
2047: -- p_start_date is set to ben_yr_perd.start_date
2048: -- p_end_date is set to ben_yr_perd.end_date
2049: -- In this case, the start date and end date values are overridden
2050: -- even if these date parameters are not null.
2051: --

Line 2048: -- p_end_date is set to ben_yr_perd.end_date

2044: --
2045: -- Priority 1:
2046: -- p_complete_year_flag = 'Y'
2047: -- p_start_date is set to ben_yr_perd.start_date
2048: -- p_end_date is set to ben_yr_perd.end_date
2049: -- In this case, the start date and end date values are overridden
2050: -- even if these date parameters are not null.
2051: --
2052: -- Priority 2:

Line 2055: -- p_end_date is set to ben_yr_perd.end_date

2051: --
2052: -- Priority 2:
2053: -- p_enrt_rt_id is not null
2054: -- p_start_date is set to ben_enrt_rt.rt_strt_dt
2055: -- p_end_date is set to ben_yr_perd.end_date
2056: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2057: -- In this case, the parameters are set only if they are null.
2058: --
2059: -- Priority 3:

Line 2062: -- p_end_date is set to ben_yr_perd.end_date

2058: --
2059: -- Priority 3:
2060: -- p_elig_per_elctbl_chc_id is not null
2061: -- p_start_date is set to ben_elig_per_elctbl_chc.enrt_cvg_strt_dt
2062: -- p_end_date is set to ben_yr_perd.end_date
2063: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2064: -- In this case, the parameters are set only if they are null.
2065: ---------------------------------------------------------------------------
2066: procedure set_default_dates(p_enrt_rt_id in number,

Line 2187: from ben_yr_perd yrp

2183: --
2184: cursor c_yrp is
2185: select yrp.end_date end_date,
2186: yrp.start_date start_date
2187: from ben_yr_perd yrp
2188: where yrp.yr_perd_id = l_yr_perd_id
2189: and yrp.business_group_id = p_business_group_id;
2190: --
2191: l_yrp c_yrp%rowtype;

Line 2199: ben_yr_perd yp

2195: CURSOR c_pl_popl_yr_period_current IS
2196: SELECT yp.end_date end_date,
2197: yp.start_date start_date
2198: FROM ben_popl_yr_perd pyp,
2199: ben_yr_perd yp
2200: WHERE pyp.pl_id = l_pl_id
2201: AND pyp.yr_perd_id = yp.yr_perd_id
2202: AND pyp.business_group_id = p_business_group_id
2203: AND l_start_date between yp.start_date AND yp.end_date

Line 4196: from ben_yr_perd yrp

4192: l_get_epe get_epe%rowtype;
4193: --
4194: cursor c_yrp is
4195: select yrp.start_date
4196: from ben_yr_perd yrp
4197: where yrp.yr_perd_id = l_get_epe.yr_perd_id
4198: and yrp.business_group_id = l_get_epe.business_group_id;
4199: --
4200: l_yr_start_date date;

Line 4398: from ben_yr_perd yrp

4394: cursor get_epe_pl_yr is
4395: select yrp.start_date, yrp.end_date, epe.pgm_id, epe.pl_id,
4396: epe.pl_typ_id, epe.business_group_id, pil.ler_id,
4397: oipl.opt_id
4398: from ben_yr_perd yrp
4399: ,ben_elig_per_elctbl_chc epe
4400: ,ben_per_in_ler pil
4401: ,ben_oipl_f oipl
4402: where epe.yr_perd_id = yrp.yr_perd_id