DBA Data[Home] [Help]

APPS.BEN_LETRG_CACHE dependencies on BEN_LER_PER_INFO_CS_LER_F

Line 89: , ben_ler_per_info_cs_ler_f lpl

85: and ( c_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
86: and ((exists
87: (select 1
88: from ben_per_info_chg_cs_ler_f psl
89: , ben_ler_per_info_cs_ler_f lpl
90: where source_table = c_source_table
91: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
92: and lpl.business_group_id = psl.business_group_id
93: and lpl.business_group_id = ler.business_group_id

Line 157: ben_ler_per_info_cs_ler_f lpl

153: (
154: EXISTS
155: (SELECT 1
156: FROM ben_per_info_chg_cs_ler_f psl,
157: ben_ler_per_info_cs_ler_f lpl
158: WHERE psl.source_table = 'BEN_ELIG_DPNT'
159: AND psl.per_info_chg_cs_ler_id =
160: lpl.per_info_chg_cs_ler_id
161: AND c_effective_date BETWEEN psl.effective_start_date