APPS.BEN_XDF_BUS dependencies on BEN_EXT_DFN

Line 24: , ben_ext_dfn dfn

20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups_perf pbg
24: , ben_ext_dfn dfn
25: where dfn.ext_dfn_id = p_ext_dfn_id
26: and pbg.business_group_id = dfn.business_group_id;
27: --
28: -- Declare local variables

Line 116: ben_xdf_shd.constraint_error('BEN_EXT_DFN_PK');

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

Line 126: ben_xdf_shd.constraint_error('BEN_EXT_DFN_PK');

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

Line 200: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK2');

196: --
197: -- raise error as FK does not relate to PK in ben_ext_file
198: -- table.
199: --
200: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK2');
201: --
202: end if;
203: --
204: close c1;

Line 276: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK1');

272: --
273: -- raise error as FK does not relate to PK in ben_ext_crit_prfl
274: -- table.
275: --
276: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK1');
277: --
278: end if;
279: --
280: close c1;

Line 1309: from ben_ext_dfn

1305: is
1306: l_proc varchar2(72) := g_package||'chk_name_unique';
1307: l_dummy char(1);
1308: cursor c1 is select null
1309: from ben_ext_dfn
1310: Where ext_dfn_id <> nvl(p_ext_dfn_id,-1)
1311: and name = p_name
1312: and ((business_group_id is null and legislation_code is null) or
1313: (legislation_code is not null and

Line 1714: from ben_ext_dfn b

1710: -- Declare cursor
1711: --
1712: cursor csr_leg_code is
1713: select b.business_group_id
1714: from ben_ext_dfn b
1715: where b.ext_dfn_id = p_ext_dfn_id
1716: ;
1717: --
1718: -- Declare local variables