APPS.BEN_HWR_BUS dependencies on BEN_HRS_WKD_IN_PERD_FCTR

Line 116: from ben_hrs_wkd_in_perd_fctr a

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

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

130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_hrs_wkd_in_perd_fctr_id is not null then
133: --
134: -- check if hrs_wkd_in_perd_fctr_id value exists in ben_hrs_wkd_in_perd_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_hrs_wkd_in_perd_fctr

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

Line 386: -- BEN_HRS_WKD_IN_PERD_FCTR table.

382: --
383: -- Description
384: -- This procedure is used to check that the foreign key for the table
385: -- is created properly. a corresponding record should exist in the
386: -- BEN_HRS_WKD_IN_PERD_FCTR table.
387: --
388: -- Pre Conditions
389: -- None.
390: --

Line 392: -- hrs_wkd_in_perd_fctr_id FK of pointing to BEN_HRS_WKD_IN_PERD_FCTR tables.

388: -- Pre Conditions
389: -- None.
390: --
391: -- In Parameters
392: -- hrs_wkd_in_perd_fctr_id FK of pointing to BEN_HRS_WKD_IN_PERD_FCTR tables.
393: -- business_group_id or record being inserted or updated
394: --
395: -- Post Success
396: -- Processing continues

Line 410: from BEN_HRS_WKD_IN_PERD_FCTR

406: --
407: l_proc varchar2(72) := g_package||'chk_hrs_wkd_in_perd_fctr_id';
408: l_dummy varchar2(1);
409: cursor c1 is select null
410: from BEN_HRS_WKD_IN_PERD_FCTR
411: where hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
412: and business_group_id = p_business_group_id;
413: --
414: