APPS.BEN_DETERMINE_DATE dependencies on BEN_POPL_YR_PERD

Line 56: ben_popl_yr_perd cpy

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
60: between yrp.start_date

Line 67: ben_popl_yr_perd cpy

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
71: between yrp.start_date

Line 78: ben_popl_yr_perd cpy,

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
82: and cpy.yr_perd_id = yrp.yr_perd_id

Line 385: ben_popl_yr_perd cpy

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
389: order by 1;

Line 394: ben_popl_yr_perd cpy

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
398: order by 1;

Line 403: ben_popl_yr_perd cpy,

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
407: and cpy.yr_perd_id = yrp.yr_perd_id

Line 846: ben_popl_yr_perd cpy

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
850: and cpy.business_group_id = l_business_group_id

Line 859: ben_popl_yr_perd cpy

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
863: and cpy.business_group_id = l_business_group_id

Line 872: ben_popl_yr_perd cpy,

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
876: and cpy.yr_perd_id = yrp.yr_perd_id