DBA Data[Home] [Help]

APPS.BEN_EAC_BUS dependencies on BEN_AGE_FCTR

Line 116: from ben_age_fctr a

112: l_dummy varchar2(1);
113: --
114: cursor c1 is
115: select null
116: from ben_age_fctr a
117: where a.age_fctr_id = p_age_fctr_id;
118: --
119: Begin
120: --

Line 134: -- check if age_fctr_id value exists in ben_age_fctr table

130: <> nvl(ben_eac_shd.g_old_rec.age_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_age_fctr_id is not null then
133: --
134: -- check if age_fctr_id value exists in ben_age_fctr table
135: --
136: open c1;
137: --
138: fetch c1 into l_dummy;

Line 143: -- raise error as FK does not relate to PK in ben_age_fctr

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