DBA Data[Home] [Help]

APPS.BEN_EGD_LER dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 50: FROM ben_ler_rltd_per_cs_ler_f lrp,

46: )
47: OR (
48: EXISTS
49: (SELECT 1
50: FROM ben_ler_rltd_per_cs_ler_f lrp,
51: ben_rltd_per_chg_cs_ler_f rpc
52: WHERE rpc.source_table = 'BEN_ELIG_DPNT'
53: AND l_session_date BETWEEN rpc.effective_start_date
54: AND rpc.effective_end_date

Line 86: FROM ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc

82: rpc.new_val,
83: rpc.old_val,
84: 'R',
85: rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
86: FROM ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc
87: WHERE lrp.ler_id = p_ler_id
88: AND lrp.business_group_id = p_new.business_group_id
89: AND lrp.business_group_id = rpc.business_group_id
90: AND l_session_date BETWEEN rpc.effective_start_date