APPS.HXC_HAT_BUS dependencies on HXC_ALIAS_TYPES

Line 31: , hxc_alias_types hat

27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , hxc_alias_types hat
32: where hat.alias_type_id = p_alias_type_id;
33: --
34: -- Declare local variables
35: --

Line 100: , hxc_alias_types hat

96: --
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups pbg
100: , hxc_alias_types hat
101: where hat.alias_type_id = p_alias_type_id;
102: --
103: -- Declare local variables
104: --

Line 222: Procedure chk_name (p_type hxc_alias_types.ALIAS_TYPE%TYPE,

218:
219: -------------------------------------------------------------------------------
220: -- |----------------------------------------------------------------|
221: -------------------------------------------------------------------------------
222: Procedure chk_name (p_type hxc_alias_types.ALIAS_TYPE%TYPE,
223: p_reference_object hxc_alias_types.REFERENCE_OBJECT%TYPE
224: ) is
225:
226: CURSOR csr_chk_alias_type IS

Line 223: p_reference_object hxc_alias_types.REFERENCE_OBJECT%TYPE

219: -------------------------------------------------------------------------------
220: -- |----------------------------------------------------------------|
221: -------------------------------------------------------------------------------
222: Procedure chk_name (p_type hxc_alias_types.ALIAS_TYPE%TYPE,
223: p_reference_object hxc_alias_types.REFERENCE_OBJECT%TYPE
224: ) is
225:
226: CURSOR csr_chk_alias_type IS
227: SELECT 'error'

Line 231: from hxc_alias_types

227: SELECT 'error'
228: FROM sys.dual
229: WHERE EXISTS (
230: SELECT 'x'
231: from hxc_alias_types
232: where alias_type = p_type and
233: reference_object = p_reference_object);
234:
235: l_error varchar2(5) := NULL;

Line 266: Procedure chk_fk_relation (p_alias_type_id hxc_alias_types.alias_type_id%TYPE

262: --
263: -------------------------------------------------------------------------------
264: -- |----------------------------------------------------------------|
265: -------------------------------------------------------------------------------
266: Procedure chk_fk_relation (p_alias_type_id hxc_alias_types.alias_type_id%TYPE
267: ) is
268: Cursor csr_chk_aldef IS
269: select 'error'
270: from sys.dual

Line 274: hxc_alias_types hat

270: from sys.dual
271: where exists(
272: select 'x'
273: from hxc_alias_definitions had,
274: hxc_alias_types hat
275: where hat.alias_type_id = p_alias_type_id and
276: hat.alias_type_id = had.alias_type_id
277: );
278: l_error varchar2(5) := NULL;