APPS.BEN_DRR_BUS dependencies on BEN_DSGN_RQMT_F

Line 114: from ben_dsgn_rqmt_f a

110: l_dummy varchar2(1);
111: --
112: cursor c1 is
113: select null
114: from ben_dsgn_rqmt_f a
115: where a.dsgn_rqmt_id = p_dsgn_rqmt_id
116: and p_effective_date
117: between a.effective_start_date
118: and a.effective_end_date;

Line 133: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table

129: and nvl(p_dsgn_rqmt_id,hr_api.g_number)
130: <> nvl(ben_drr_shd.g_old_rec.dsgn_rqmt_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table
134: --
135: open c1;
136: --
137: fetch c1 into l_dummy;

Line 142: -- raise error as FK does not relate to PK in ben_dsgn_rqmt_f

138: if c1%notfound then
139: --
140: close c1;
141: --
142: -- raise error as FK does not relate to PK in ben_dsgn_rqmt_f
143: -- table.
144: --
145: ben_drr_shd.constraint_error('BEN_DSGN_RQMT_RLSHP_TYP_DT1');
146: --

Line 332: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table

328: --
329: hr_utility.set_location('Entering:'||l_proc,5);
330: --
331: --
332: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table
333: --
334: open c_chk_uniq_dsgn_rqmt;
335: --
336: fetch c_chk_uniq_dsgn_rqmt into l_dummy;