DBA Data[Home] [Help]

APPS.BEN_XID_BUS dependencies on BEN_EXT_INCL_DATA_ELMT

Line 23: , ben_ext_incl_data_elmt xid

19: --
20: cursor csr_sec_grp is
21: select pbg.security_group_id
22: from per_business_groups pbg
23: , ben_ext_incl_data_elmt xid
24: where xid.ext_incl_data_elmt_id = p_ext_incl_data_elmt_id
25: and pbg.business_group_id = xid.business_group_id;
26: --
27: -- Declare local variables

Line 116: ben_xid_shd.constraint_error('BEN_EXT_INCL_DATA_ELMT_PK');

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

Line 126: ben_xid_shd.constraint_error('BEN_EXT_INCL_DATA_ELMT_PK');

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

Line 271: ben_ext_incl_data_elmt b

267: --
268: cursor csr_leg_code is
269: select a.legislation_code
270: from per_business_groups a,
271: ben_ext_incl_data_elmt b
272: where b.ext_incl_data_elmt_id = p_ext_incl_data_elmt_id
273: and a.business_group_id(+) = b.business_group_id;
274: --
275: -- Declare local variables