APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_YR_PERD

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

2168: -- To get what sets what, refer to the following logic.
2169: --
2170: -- Priority 1:
2171: -- p_complete_year_flag = 'Y'
2172: -- p_start_date is set to ben_yr_perd.start_date
2173: -- p_end_date is set to ben_yr_perd.end_date
2174: -- In this case, the start date and end date values are overridden
2175: -- even if these date parameters are not null.
2176: --

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

2169: --
2170: -- Priority 1:
2171: -- p_complete_year_flag = 'Y'
2172: -- p_start_date is set to ben_yr_perd.start_date
2173: -- p_end_date is set to ben_yr_perd.end_date
2174: -- In this case, the start date and end date values are overridden
2175: -- even if these date parameters are not null.
2176: --
2177: -- Priority 2:

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

2176: --
2177: -- Priority 2:
2178: -- p_enrt_rt_id is not null
2179: -- p_start_date is set to ben_enrt_rt.rt_strt_dt
2180: -- p_end_date is set to ben_yr_perd.end_date
2181: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2182: -- In this case, the parameters are set only if they are null.
2183: --
2184: -- Priority 3:

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

2183: --
2184: -- Priority 3:
2185: -- p_elig_per_elctbl_chc_id is not null
2186: -- p_start_date is set to ben_elig_per_elctbl_chc.enrt_cvg_strt_dt
2187: -- p_end_date is set to ben_yr_perd.end_date
2188: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2189: -- In this case, the parameters are set only if they are null.
2190: ---------------------------------------------------------------------------
2191: procedure set_default_dates(p_enrt_rt_id in number,

Line 2312: from ben_yr_perd yrp

2308: --
2309: cursor c_yrp is
2310: select yrp.end_date end_date,
2311: yrp.start_date start_date
2312: from ben_yr_perd yrp
2313: where yrp.yr_perd_id = l_yr_perd_id
2314: and yrp.business_group_id = p_business_group_id;
2315: --
2316: l_yrp c_yrp%rowtype;

Line 2324: ben_yr_perd yp

2320: CURSOR c_pl_popl_yr_period_current IS
2321: SELECT yp.end_date end_date,
2322: yp.start_date start_date
2323: FROM ben_popl_yr_perd pyp,
2324: ben_yr_perd yp
2325: WHERE pyp.pl_id = l_pl_id
2326: AND pyp.yr_perd_id = yp.yr_perd_id
2327: AND pyp.business_group_id = p_business_group_id
2328: AND l_start_date between yp.start_date AND yp.end_date

Line 4516: from ben_yr_perd yrp

4512: l_get_epe get_epe%rowtype;
4513: --
4514: cursor c_yrp is
4515: select yrp.start_date
4516: from ben_yr_perd yrp
4517: where yrp.yr_perd_id = l_get_epe.yr_perd_id
4518: and yrp.business_group_id = l_get_epe.business_group_id;
4519: --
4520: l_yr_start_date date;

Line 4718: from ben_yr_perd yrp

4714: cursor get_epe_pl_yr is
4715: select yrp.start_date, yrp.end_date, epe.pgm_id, epe.pl_id,
4716: epe.pl_typ_id, epe.business_group_id, pil.ler_id,
4717: oipl.opt_id
4718: from ben_yr_perd yrp
4719: ,ben_elig_per_elctbl_chc epe
4720: ,ben_per_in_ler pil
4721: ,ben_oipl_f oipl
4722: where epe.yr_perd_id = yrp.yr_perd_id