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_ASG_LER dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 45: , ben_ler_rltd_per_cs_ler_f lrp

41: )
42: OR (exists
43: (select 1
44: from ben_rltd_per_chg_cs_ler_f rpc
45: , ben_ler_rltd_per_cs_ler_f lrp
46: where source_table = 'PER_ALL_ASSIGNMENTS_F'
47: and lrp.business_group_id = rpc.business_group_id
48: and lrp.business_group_id = ler.business_group_id
49: and l_session_date between rpc.effective_start_date

Line 72: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc

68: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
69: and source_table = 'PER_ALL_ASSIGNMENTS_F'
70: UNION
71: select rpc.source_column, rpc.new_val, rpc.old_val, 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
72: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc
73: where lrp.ler_id = p_ler_id and
74: lrp.business_group_id = p_new.business_group_id
75: and lrp.business_group_id = rpc.business_group_id
76: and l_session_date between rpc.effective_start_date