APPS.BEN_PRO_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 83: from ben_rltd_per_chg_cs_ler_f rpc

79: and lpl.ler_id = ler.ler_id)
80: )
81: OR (exists
82: (select 1
83: from ben_rltd_per_chg_cs_ler_f rpc
84: , ben_ler_rltd_per_cs_ler_f lrp
85: where source_table = 'PER_PAY_PROPOSALS'
86: and lrp.business_group_id = rpc.business_group_id
87: and lrp.business_group_id = ler.business_group_id

Line 111: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc

107: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
108: and source_table = 'PER_PAY_PROPOSALS'
109: UNION
110: 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
111: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc
112: where lrp.ler_id = p_ler_id and
113: lrp.business_group_id = p_new.business_group_id
114: and lrp.business_group_id = rpc.business_group_id
115: and l_session_date between rpc.effective_start_date

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

135: l_changed BOOLEAN;
136: l_ler_id NUMBER;
137: l_typ_cd ben_ler_f.typ_cd%type ;
138: l_ocrd_dt_cd VARCHAR2(30);
139: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
140: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
141: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
142: l_per_info_chg_cs_ler_rl number;
143: l_ovn NUMBER;

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

136: l_ler_id NUMBER;
137: l_typ_cd ben_ler_f.typ_cd%type ;
138: l_ocrd_dt_cd VARCHAR2(30);
139: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
140: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
141: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
142: l_per_info_chg_cs_ler_rl number;
143: l_ovn NUMBER;
144: l_ptnl_id NUMBER;

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

137: l_typ_cd ben_ler_f.typ_cd%type ;
138: l_ocrd_dt_cd VARCHAR2(30);
139: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
140: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
141: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
142: l_per_info_chg_cs_ler_rl number;
143: l_ovn NUMBER;
144: l_ptnl_id NUMBER;
145: l_effective_end_date DATE := to_date('31-12-4712','DD-MM-YYYY');