APPS.BEN_EGD_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 51: ben_rltd_per_chg_cs_ler_f rpc

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
55: AND rpc.rltd_per_chg_cs_ler_id =

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

Line 132: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);

128: --
129: l_changed BOOLEAN;
130: l_ler_id NUMBER;
131: l_typ_cd ben_ler_f.typ_cd%type ;
132: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
133: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
134: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
135: l_ocrd_dt_cd VARCHAR2(30);
136: l_per_info_chg_cs_ler_rl NUMBER;

Line 133: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);

129: l_changed BOOLEAN;
130: l_ler_id NUMBER;
131: l_typ_cd ben_ler_f.typ_cd%type ;
132: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
133: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
134: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
135: l_ocrd_dt_cd VARCHAR2(30);
136: l_per_info_chg_cs_ler_rl NUMBER;
137: l_rule_output VARCHAR2(1);

Line 134: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);

130: l_ler_id NUMBER;
131: l_typ_cd ben_ler_f.typ_cd%type ;
132: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
133: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
134: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
135: l_ocrd_dt_cd VARCHAR2(30);
136: l_per_info_chg_cs_ler_rl NUMBER;
137: l_rule_output VARCHAR2(1);
138: l_ovn NUMBER;