APPS.BEN_EEV_LER dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 39: from ben_per_info_chg_cs_ler_f psl

35: and ler.effective_end_date -- For Bug 3299709
36: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
37: and exists
38: (select 1
39: from ben_per_info_chg_cs_ler_f psl
40: ,ben_ler_per_info_cs_ler lpl
41: where source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
42: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
43: and lpl.business_group_id = psl.business_group_id

Line 67: from ben_ler_per_info_cs_ler lpl, ben_per_info_chg_cs_ler_f psl

63: order by ler.ler_id;
64: --
65: cursor get_ler_col(p_ler_id IN NUMBER) is
66: 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
67: from ben_ler_per_info_cs_ler lpl, ben_per_info_chg_cs_ler_f psl
68: where lpl.ler_id = p_ler_id and
69: lpl.business_group_id = l_business_group_id
70: and lpl.business_group_id = psl.business_group_id
71: and l_session_date between psl.effective_start_date