APPS.BEN_LRC_BUS dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 120: from ben_rltd_per_chg_cs_ler_f a

116: l_dummy varchar2(1);
117: --
118: cursor c1 is
119: select null
120: from ben_rltd_per_chg_cs_ler_f a
121: where a.rltd_per_chg_cs_ler_id = p_rltd_per_chg_cs_ler_id
122: and p_effective_date between effective_start_date
123: and effective_end_date;
124: --

Line 161: -- ben_rltd_per_chg_cs_ler_f table

157: <> nvl(ben_lrc_shd.g_old_rec.rltd_per_chg_cs_ler_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if rltd_per_chg_cs_ler_id value exists in
161: -- ben_rltd_per_chg_cs_ler_f table
162: --
163: open c1;
164: fetch c1 into l_dummy;
165: if c1%notfound then

Line 167: -- raise error as FK does not relate to PK in ben_rltd_per_chg_cs_ler_f

163: open c1;
164: fetch c1 into l_dummy;
165: if c1%notfound then
166: close c1;
167: -- raise error as FK does not relate to PK in ben_rltd_per_chg_cs_ler_f
168: -- table.
169: ben_lrc_shd.constraint_error('BEN_LER_RLTD_PER_CS_LER_F_FK2');
170: end if;
171: close c1;