APPS.BEN_XDD_BUS dependencies on BEN_EXT_DATA_ELMT_DECD

Line 23: , ben_ext_data_elmt_decd xdd

19: --
20: cursor csr_sec_grp is
21: select pbg.security_group_id
22: from per_business_groups pbg
23: , ben_ext_data_elmt_decd xdd
24: where xdd.ext_data_elmt_decd_id = p_ext_data_elmt_decd_id
25: and pbg.business_group_id = xdd.business_group_id;
26: --
27: -- Declare local variables

Line 116: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');

112: <> ben_xdd_shd.g_old_rec.ext_data_elmt_decd_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');
117: --
118: elsif not l_api_updating then
119: --
120: -- check if PK is null

Line 126: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');

122: if p_ext_data_elmt_decd_id is not null then
123: --
124: -- raise error as PK is not null
125: --
126: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');
127: --
128: end if;
129: --
130: end if;

Line 199: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_FK1');

195: --
196: -- raise error as FK does not relate to PK in ben_ext_data_elmt
197: -- table.
198: --
199: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_FK1');
200: --
201: end if;
202: --
203: close c1;

Line 247: from ben_ext_data_elmt_decd

243: is
244: l_proc varchar2(72) := g_package||'chk_val_unique';
245: l_dummy char(1);
246: cursor c1 is select null
247: from ben_ext_data_elmt_decd
248: Where ext_data_elmt_id = p_ext_data_elmt_id
249: and ext_data_elmt_decd_id <> nvl(p_ext_data_elmt_decd_id,-1)
250: and val = p_val
251: -- and business_group_id = p_business_group_id

Line 535: ben_ext_data_elmt_decd b

531: --
532: cursor csr_leg_code is
533: select a.legislation_code
534: from per_business_groups a,
535: ben_ext_data_elmt_decd b
536: where b.ext_data_elmt_decd_id = p_ext_data_elmt_decd_id
537: and a.business_group_id(+) = b.business_group_id;
538: --
539: -- Declare local variables