APPS.BEN_CRT_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 44: from ben_rltd_per_chg_cs_ler_f rpc

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

Line 70: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc

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

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

96: and nvl(date_end,l_session_date)
97: and personal_flag = 'Y'
98: order by person_id;
99: --
100: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
101: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
102: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
103:
104: l_changed BOOLEAN;

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

97: and personal_flag = 'Y'
98: order by person_id;
99: --
100: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
101: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
102: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
103:
104: l_changed BOOLEAN;
105: l_ler_id NUMBER;

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

98: order by person_id;
99: --
100: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
101: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
102: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
103:
104: l_changed BOOLEAN;
105: l_ler_id NUMBER;
106: l_typ_cd ben_ler_f.typ_cd%type ;