DBA Data[Home] [Help]

APPS.BEN_PLN_CACHE dependencies on BEN_POPL_YR_PERD

Line 65: -- ben_popl_yr_perd cpy,

61: from ben_ptip_f ctp,
62: ben_pl_f pln,
63: ben_pl_typ_f ptp,
64: ben_plip_f plp
65: -- ben_popl_yr_perd cpy,
66: -- ben_yr_perd yrp
67: where
68: /* Hint joins */
69: plp.pgm_id = c_pgm_id

Line 80: from ben_popl_yr_perd cpy,

76: between ptp.effective_start_date
77: and ptp.effective_end_date
78: and (p_mode IN ('P','G','D') or
79: exists (select null
80: from ben_popl_yr_perd cpy,
81: ben_yr_perd yrp
82: where cpy.pl_id = pln.pl_id
83: and cpy.yr_perd_id = yrp.yr_perd_id
84: and c_effective_date

Line 263: -- ben_popl_yr_perd cpy,

259: from ben_ptip_f ctp,
260: ben_pl_f pln,
261: ben_pl_typ_f ptp,
262: ben_plip_f plp
263: -- ben_popl_yr_perd cpy,
264: -- ben_yr_perd yrp
265: where
266: /* Hint joins */
267: plp.pgm_id = c_pgm_id

Line 280: from ben_popl_yr_perd cpy,

276: and ctp.pgm_id = c_pgm_id
277:
278: and (p_mode in ('G','D') or
279: exists (select null
280: from ben_popl_yr_perd cpy,
281: ben_yr_perd yrp
282: where cpy.pl_id = pln.pl_id
283: and cpy.yr_perd_id = yrp.yr_perd_id
284: and c_effective_date