APPS.BEN_COP_CACHE dependencies on BEN_YR_PERD

Line 37: -- ben_yr_perd yrp

33: from
34: ben_pl_f pln,
35: ben_oipl_f cop
36: -- ben_popl_yr_perd cpy,
37: -- ben_yr_perd yrp
38: where pln.pl_id = c_pl_id
39: and c_effective_date
40: between pln.effective_start_date
41: and pln.effective_end_date

Line 49: ben_yr_perd yrp

45: and cop.effective_end_date
46: and (p_mode IN ('P','G','D') or
47: exists (select null
48: from ben_popl_yr_perd cpy,
49: ben_yr_perd yrp
50: where cpy.pl_id = pln.pl_id
51: and cpy.yr_perd_id = yrp.yr_perd_id
52: and c_effective_date
53: between yrp.start_date

Line 75: -- ben_yr_perd yrp,

71: cop.trk_inelig_per_flag
72: from ben_pl_f pln,
73: ben_oipl_f cop,
74: -- ben_popl_yr_perd cpy,
75: -- ben_yr_perd yrp,
76: ben_opt_f opt
77: where pln.pl_id = c_pl_id
78: and c_effective_date
79: between pln.effective_start_date

Line 88: ben_yr_perd yrp

84: and cop.effective_end_date
85: and (p_mode IN ('P','G','D') or
86: exists (select null
87: from ben_popl_yr_perd cpy,
88: ben_yr_perd yrp
89: where cpy.pl_id = pln.pl_id
90: and cpy.yr_perd_id = yrp.yr_perd_id
91: and c_effective_date
92: between yrp.start_date