APPS.BEN_PEN_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 47: from ben_rltd_per_chg_cs_ler_f rpc

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

Line 73: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc

69: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
70: and source_table = 'BEN_PRTT_ENRT_RSLT_F'
71: UNION
72: 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
73: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc
74: where lrp.ler_id = p_ler_id and
75: lrp.business_group_id = p_new.business_group_id
76: and lrp.business_group_id = rpc.business_group_id
77: and l_session_date between rpc.effective_start_date

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

99: and nvl(date_end,l_session_date)
100: order by person_id;
101: --
102: l_changed BOOLEAN;
103: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
104: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
105: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
106: l_per_info_chg_cs_ler_rl number;
107: l_rule_output VARCHAR2(1);

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

100: order by person_id;
101: --
102: l_changed BOOLEAN;
103: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
104: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
105: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
106: l_per_info_chg_cs_ler_rl number;
107: l_rule_output VARCHAR2(1);
108: l_ovn NUMBER;

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

101: --
102: l_changed BOOLEAN;
103: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
104: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
105: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
106: l_per_info_chg_cs_ler_rl number;
107: l_rule_output VARCHAR2(1);
108: l_ovn NUMBER;
109: l_ptnl_id NUMBER;