61: ,c_source_table varchar2
62: )
63: IS
64: select 1
65: from ben_rltd_per_chg_cs_ler_f rpc
66: where rpc.business_group_id = c_business_group_id
67: and c_effective_date
68: between rpc.effective_start_date and rpc.effective_end_date
69: and rpc.source_table = c_source_table;
96: and lpl.ler_id = ler.ler_id)
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
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
175: AND rpc.rltd_per_chg_cs_ler_id =