APPS.BEN_PPR_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 43: from ben_rltd_per_chg_cs_ler_f rpc

39: and lpl.ler_id = ler.ler_id)
40: )
41: OR (exists
42: (select 1
43: from ben_rltd_per_chg_cs_ler_f rpc
44: , ben_ler_rltd_per_cs_ler_f lrp
45: where source_table = 'PER_PERFORMANCE_REVIEWS'
46: and lrp.business_group_id = rpc.business_group_id
47: and lrp.business_group_id = ler.business_group_id

Line 78: , ben_rltd_per_chg_cs_ler_f rpc

74: , rpc.new_val
75: , rpc.old_val
76: , 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
77: from ben_ler_rltd_per_cs_ler_f lrp
78: , ben_rltd_per_chg_cs_ler_f rpc
79: where lrp.ler_id = p_ler_id
80: and lrp.business_group_id = p_new.business_group_id
81: and lrp.business_group_id = rpc.business_group_id
82: and l_session_date between

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

119: l_ovn NUMBER;
120: l_ptnl_id NUMBER;
121: l_hld_person_id NUMBER;
122: l_ocrd_dt_cd VARCHAR2(30);
123: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
124: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
125: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
126: l_per_info_chg_cs_ler_rl number;
127: l_rule_output VARCHAR2(1);

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

120: l_ptnl_id NUMBER;
121: l_hld_person_id NUMBER;
122: l_ocrd_dt_cd VARCHAR2(30);
123: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
124: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
125: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
126: l_per_info_chg_cs_ler_rl number;
127: l_rule_output VARCHAR2(1);
128: l_type VARCHAR2(1);

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

121: l_hld_person_id NUMBER;
122: l_ocrd_dt_cd VARCHAR2(30);
123: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
124: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
125: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
126: l_per_info_chg_cs_ler_rl number;
127: l_rule_output VARCHAR2(1);
128: l_type VARCHAR2(1);
129: l_le_exists VARCHAR2(1);