APPS.BEN_BCD_BUS dependencies on BEN_CWB_MATRIX

Line 30: , ben_cwb_matrix_dtl bcd

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , ben_cwb_matrix_dtl bcd
31: where bcd.cwb_matrix_dtl_id = p_cwb_matrix_dtl_id
32: and pbg.business_group_id = bcd.business_group_id;
33: --
34: -- Declare local variables

Line 94: , ben_cwb_matrix_dtl bcd

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , ben_cwb_matrix_dtl bcd
95: where bcd.cwb_matrix_dtl_id = p_cwb_matrix_dtl_id
96: and pbg.business_group_id = bcd.business_group_id;
97: --
98: -- Declare local variables

Line 241: from ben_cwb_matrix a

237: l_dummy varchar2(1);
238: --
239: cursor c1 is
240: select null
241: from ben_cwb_matrix a
242: where a.cwb_matrix_id = p_cwb_matrix_id;
243: --
244: Begin
245: --

Line 258: -- ben_cwb_matrix table

254: <> nvl(ben_bcd_shd.g_old_rec.cwb_matrix_id, hr_api.g_number)
255: or not l_api_updating) then
256: --
257: -- check if cwb_matrix_id value exists in
258: -- ben_cwb_matrix table
259: --
260: open c1;
261: --
262: fetch c1 into l_dummy;

Line 267: -- raise error as FK does not relate to PK in ben_cwb_matrix

263: if c1%notfound then
264: --
265: close c1;
266: --
267: -- raise error as FK does not relate to PK in ben_cwb_matrix
268: -- table.
269: --
270: ben_bcd_shd.constraint_error('BEN_CWB_MATRIX_DTL_FK1');
271: --

Line 270: ben_bcd_shd.constraint_error('BEN_CWB_MATRIX_DTL_FK1');

266: --
267: -- raise error as FK does not relate to PK in ben_cwb_matrix
268: -- table.
269: --
270: ben_bcd_shd.constraint_error('BEN_CWB_MATRIX_DTL_FK1');
271: --
272: end if;
273: --
274: close c1;