APPS.BEN_ECD_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 55: from ben_rltd_per_chg_cs_ler_f rpc

51: and lpl.ler_id = ler.ler_id)
52: )
53: OR (exists
54: (select 1
55: from ben_rltd_per_chg_cs_ler_f rpc
56: , ben_ler_rltd_per_cs_ler_f lrp
57: where source_table = 'BEN_ELIG_CVRD_DPNT_F'
58: and lrp.business_group_id = rpc.business_group_id
59: and lrp.business_group_id = ler.business_group_id

Line 81: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc

77: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
78: and source_table = 'BEN_ELIG_CVRD_DPNT_F'
79: UNION
80: select rpc.source_column, rpc.new_val, rpc.old_val, 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
81: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc
82: where lrp.ler_id = p_ler_id and
83: lrp.business_group_id = p_new.business_group_id
84: and lrp.business_group_id = rpc.business_group_id
85: and l_session_date between rpc.effective_start_date

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

111: --
112: l_changed BOOLEAN;
113: l_ler_id NUMBER;
114: l_typ_cd ben_ler_f.typ_cd%type ;
115: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
116: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
117: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
118: l_ocrd_dt_cd VARCHAR2(30);
119: l_per_info_chg_cs_ler_rl number;

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

112: l_changed BOOLEAN;
113: l_ler_id NUMBER;
114: l_typ_cd ben_ler_f.typ_cd%type ;
115: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
116: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
117: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
118: l_ocrd_dt_cd VARCHAR2(30);
119: l_per_info_chg_cs_ler_rl number;
120: l_rule_output VARCHAR2(1);

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

113: l_ler_id NUMBER;
114: l_typ_cd ben_ler_f.typ_cd%type ;
115: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
116: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
117: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
118: l_ocrd_dt_cd VARCHAR2(30);
119: l_per_info_chg_cs_ler_rl number;
120: l_rule_output VARCHAR2(1);
121: l_ovn NUMBER;