APPS.BEN_DETERMINE_DATE dependencies on BEN_YR_PERD

Line 55: from ben_yr_perd yrp,

51:
52: cursor c_pgm_popl_yr is
53: select yrp.start_date,
54: yrp.end_date
55: from ben_yr_perd yrp,
56: ben_popl_yr_perd cpy
57: where cpy.pgm_id = p_pgm_id
58: and cpy.yr_perd_id = yrp.yr_perd_id
59: and l_effective_date

Line 66: from ben_yr_perd yrp,

62: --
63: cursor c_pl_popl_yr is
64: select yrp.start_date,
65: yrp.end_date
66: from ben_yr_perd yrp,
67: ben_popl_yr_perd cpy
68: where cpy.pl_id = p_pl_id
69: and cpy.yr_perd_id = yrp.yr_perd_id
70: and l_effective_date

Line 77: from ben_yr_perd yrp,

73: --
74: cursor c_oipl_popl_yr is
75: select yrp.start_date,
76: yrp.end_date
77: from ben_yr_perd yrp,
78: ben_popl_yr_perd cpy,
79: ben_oipl_f cop
80: where cpy.pl_id = cop.pl_id
81: and cop.oipl_id = p_oipl_id

Line 384: from ben_yr_perd yrp,

380: l_effective_date date;
381:
382: cursor c_pgm_next_popl_yr is
383: select yrp.start_date, yrp.end_date
384: from ben_yr_perd yrp,
385: ben_popl_yr_perd cpy
386: where cpy.pgm_id = p_pgm_id
387: and cpy.yr_perd_id = yrp.yr_perd_id
388: and l_effective_date < yrp.start_date

Line 393: from ben_yr_perd yrp,

389: order by 1;
390: --
391: cursor c_pl_next_popl_yr is
392: select yrp.start_date, yrp.end_date
393: from ben_yr_perd yrp,
394: ben_popl_yr_perd cpy
395: where cpy.pl_id = p_pl_id
396: and cpy.yr_perd_id = yrp.yr_perd_id
397: and l_effective_date < yrp.start_date

Line 402: from ben_yr_perd yrp,

398: order by 1;
399: --
400: cursor c_oipl_next_popl_yr is
401: select yrp.start_date, yrp.end_date
402: from ben_yr_perd yrp,
403: ben_popl_yr_perd cpy,
404: ben_oipl_f cop
405: where cpy.pl_id = cop.pl_id
406: and cop.oipl_id = p_oipl_id

Line 845: from ben_yr_perd yrp,

841: --
842: cursor c_pgm_popl_lim_yr is
843: select yrp.lmtn_yr_strt_dt,
844: yrp.lmtn_yr_end_dt
845: from ben_yr_perd yrp,
846: ben_popl_yr_perd cpy
847: where cpy.pgm_id = l_pgm_id
848: and cpy.yr_perd_id = yrp.yr_perd_id
849: and yrp.business_group_id = l_business_group_id

Line 858: from ben_yr_perd yrp,

854: --
855: cursor c_pl_popl_lim_yr is
856: select yrp.lmtn_yr_strt_dt,
857: yrp.lmtn_yr_end_dt
858: from ben_yr_perd yrp,
859: ben_popl_yr_perd cpy
860: where cpy.pl_id = l_pl_id
861: and cpy.yr_perd_id = yrp.yr_perd_id
862: and yrp.business_group_id = l_business_group_id

Line 871: from ben_yr_perd yrp,

867: --
868: cursor c_oipl_popl_lim_yr is
869: select yrp.lmtn_yr_strt_dt,
870: yrp.lmtn_yr_end_dt
871: from ben_yr_perd yrp,
872: ben_popl_yr_perd cpy,
873: ben_oipl_f cop
874: where cpy.pl_id = cop.pl_id
875: and cop.oipl_id = l_oipl_id