DBA Data[Home] [Help]

APPS.BEN_ECP_BUS dependencies on BEN_CMBN_AGE_LOS_FCTR

Line 133: from ben_cmbn_age_los_fctr a

129: --
130: --
131: cursor c1 is
132: select null
133: from ben_cmbn_age_los_fctr a
134: where a.cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id
135: and a.business_group_id + 0 = p_business_group_id;
136: --
137: Begin

Line 151: -- check if cmbn_age_los_fctr_id value exists in ben_cmbn_age_los_fctr table

147: and nvl(p_cmbn_age_los_fctr_id,hr_api.g_number)
148: <> nvl(ben_ecp_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if cmbn_age_los_fctr_id value exists in ben_cmbn_age_los_fctr table
152: --
153: open c1;
154: --
155: fetch c1 into l_dummy;

Line 160: -- raise error as FK does not relate to PK in ben_cmbn_age_los_fctr

156: if c1%notfound then
157: --
158: close c1;
159: --
160: -- raise error as FK does not relate to PK in ben_cmbn_age_los_fctr
161: -- table.
162: --
163: ben_ecp_shd.constraint_error('BEN_ELIG_CMBN_A_S_FK1');
164: --