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_RLTD_PER_CHG_CS_LER_F

Line 65: from ben_rltd_per_chg_cs_ler_f rpc

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;

Line 100: from ben_rltd_per_chg_cs_ler_f rpc

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

Line 171: ben_rltd_per_chg_cs_ler_f rpc

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 =