APPS.BEN_PPF_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 46: from ben_rltd_per_chg_cs_ler_f rpc

42: and lpl.ler_id = ler.ler_id)
43: )
44: OR (exists
45: (select 1
46: from ben_rltd_per_chg_cs_ler_f rpc
47: , ben_ler_rltd_per_cs_ler_f lrp
48: where source_table = 'PER_ALL_PEOPLE_F'
49: and lrp.business_group_id = rpc.business_group_id
50: and lrp.business_group_id = ler.business_group_id

Line 87: , ben_rltd_per_chg_cs_ler_f rpc

83: , rpc.new_val
84: , rpc.old_val
85: , 'R', 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
87: , ben_rltd_per_chg_cs_ler_f rpc
88: where lrp.ler_id = p_ler_id
89: and lrp.business_group_id = p_new.business_group_id
90: and lrp.business_group_id = rpc.business_group_id
91: and l_session_date between

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

134: l_ovn NUMBER;
135: l_ptnl_id NUMBER;
136: l_hld_person_id NUMBER;
137: l_ocrd_dt_cd VARCHAR2(30);
138: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
139: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
140: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
141: l_per_info_chg_cs_ler_rl number;
142: l_rule_output VARCHAR2(1);

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

135: l_ptnl_id NUMBER;
136: l_hld_person_id NUMBER;
137: l_ocrd_dt_cd VARCHAR2(30);
138: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
139: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
140: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
141: l_per_info_chg_cs_ler_rl number;
142: l_rule_output VARCHAR2(1);
143: l_type VARCHAR2(1);

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

136: l_hld_person_id NUMBER;
137: l_ocrd_dt_cd VARCHAR2(30);
138: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
139: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
140: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
141: l_per_info_chg_cs_ler_rl number;
142: l_rule_output VARCHAR2(1);
143: l_type VARCHAR2(1);
144: l_le_exists VARCHAR2(1);