97: )
98: OR (exists
99: (select 1
100: from ben_rltd_per_chg_cs_ler_f rpc
101: , ben_ler_rltd_per_cs_ler_f lrp
102: where source_table = c_source_table
103: and lrp.business_group_id = rpc.business_group_id
104: and lrp.business_group_id = ler.business_group_id
105: and c_effective_date between rpc.effective_start_date
166: )
167: OR (
168: EXISTS
169: (SELECT 1
170: FROM ben_ler_rltd_per_cs_ler_f lrp,
171: ben_rltd_per_chg_cs_ler_f rpc
172: WHERE rpc.source_table = 'BEN_ELIG_DPNT'
173: AND c_effective_date BETWEEN rpc.effective_start_date
174: AND rpc.effective_end_date