DBA Data[Home] [Help]

APPS.BEN_BCD_BUS dependencies on BEN_CWB_MATRIX_DTL

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 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;