DBA Data[Home] [Help]

APPS.BEN_EGD_LER dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 36: FROM ben_per_info_chg_cs_ler_f psl,

32: AND (
33: (
34: EXISTS
35: (SELECT 1
36: FROM ben_per_info_chg_cs_ler_f psl,
37: ben_ler_per_info_cs_ler_f lpl
38: WHERE psl.source_table = 'BEN_ELIG_DPNT'
39: AND psl.per_info_chg_cs_ler_id =
40: lpl.per_info_chg_cs_ler_id

Line 70: FROM ben_ler_per_info_cs_ler_f lpl, ben_per_info_chg_cs_ler_f psl

66: psl.new_val,
67: psl.old_val,
68: 'P',
69: psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag, lpl.chg_mandatory_cd
70: FROM ben_ler_per_info_cs_ler_f lpl, ben_per_info_chg_cs_ler_f psl
71: WHERE lpl.ler_id = p_ler_id
72: AND lpl.business_group_id = p_new.business_group_id
73: AND lpl.business_group_id = psl.business_group_id
74: AND l_session_date BETWEEN psl.effective_start_date