APPS.BEN_EHW_BUS dependencies on BEN_HRS_WKD_IN_PERD_FCTR

Line 121: from ben_hrs_wkd_in_perd_fctr a

117: l_exists varchar2(1);
118: --
119: cursor c1 is
120: select null
121: from ben_hrs_wkd_in_perd_fctr a
122: where a.hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
123: and a.business_group_id + 0 = p_business_group_id;
124: --
125: cursor c3 is

Line 149: -- check if hrs_wkd_in_perd_fctr_id value exists in ben_hrs_wkd_in_perd_fctr table

145: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)
146: <> nvl(ben_ehw_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
147: or not l_api_updating) then
148: --
149: -- check if hrs_wkd_in_perd_fctr_id value exists in ben_hrs_wkd_in_perd_fctr table
150: --
151: open c1;
152: --
153: fetch c1 into l_dummy;

Line 158: -- raise error as FK does not relate to PK in ben_hrs_wkd_in_perd_fctr

154: if c1%notfound then
155: --
156: close c1;
157: --
158: -- raise error as FK does not relate to PK in ben_hrs_wkd_in_perd_fctr
159: -- table.
160: --
161: ben_ehw_shd.constraint_error('BEN_ELIG_HRS_WKD_FK1');
162: --