DBA Data[Home] [Help]

APPS.BEN_PRV_LER dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 43: from ben_per_info_chg_cs_ler_f psl

39: and l_session_date between ler.effective_start_date
40: and ler.effective_end_date -- For Bug 3299709
41: and ((exists
42: (select 1
43: from ben_per_info_chg_cs_ler_f psl
44: , ben_ler_per_info_cs_ler_f lpl
45: where source_table = 'BEN_PRTT_RT_VAL'
46: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
47: and lpl.business_group_id = psl.business_group_id

Line 73: from ben_ler_per_info_cs_ler_f lpl, ben_per_info_chg_cs_ler_f psl

69: order by ler.ler_id;
70: --
71: cursor get_ler_col(p_ler_id IN NUMBER) is
72: select psl.source_column, psl.new_val, psl.old_val, 'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag, lpl.chg_mandatory_cd
73: from ben_ler_per_info_cs_ler_f lpl, ben_per_info_chg_cs_ler_f psl
74: where lpl.ler_id = p_ler_id and
75: lpl.business_group_id = p_new.business_group_id
76: and lpl.business_group_id = psl.business_group_id
77: and l_session_date between psl.effective_start_date