eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_LETRG_CACHE dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 52: from ben_per_info_chg_cs_ler_f psl

48: ,c_source_table varchar2
49: )
50: IS
51: select 1
52: from ben_per_info_chg_cs_ler_f psl
53: where psl.business_group_id = c_business_group_id
54: and c_effective_date
55: between psl.effective_start_date and psl.effective_end_date
56: and psl.source_table = c_source_table;

Line 88: from ben_per_info_chg_cs_ler_f psl

84: and ler.effective_end_date
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

Line 156: FROM ben_per_info_chg_cs_ler_f psl,

152: AND (
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