DBA Data[Home] [Help]

APPS.BEN_LETRG_CACHE dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 101: , ben_ler_rltd_per_cs_ler_f lrp

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

Line 170: FROM ben_ler_rltd_per_cs_ler_f lrp,

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