93: -- attached to this plan(this plan id is used as group_pl_id
94: -- in other plans)
95: begin
96: select null into l_dummy 97: from dual 98: where exists(select null from ben_pl_f pl
99: where pl.group_pl_id = p_pl_id
100: and pl.pl_id <> p_pl_id
101: and p_effective_date between pl.effective_start_date
[Home] [Help]