APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_MAPPING_COMP_USAGES

Line 14: from hxc_mapping_comp_usages mcu,

10: return NUMBER is
11:
12: cursor c_delete(p_info_type_basis in VARCHAR2) is
13: select bbi.bld_blk_info_type_id
14: from hxc_mapping_comp_usages mcu,
15: hxc_mapping_components mc,
16: hxc_bld_blk_info_types bbi
17: where mcu.mapping_component_id = mc.mapping_component_id
18: and mc.bld_blk_info_type_id = bbi.bld_blk_info_type_id

Line 44: from hxc_mapping_comp_usages u,

40: ,p_process_map in HXC_DEPOSIT_PROCESSES.NAME%TYPE) RETURN BOOLEAN is
41:
42: cursor field_already_mapped(p_id in number,p_name in varchar2) is
43: SELECT 'Y'
44: from hxc_mapping_comp_usages u,
45: hxc_mappings m
46: where m.name = p_name
47: and u.mapping_id = m.mapping_id
48: and u.mapping_component_id in

Line 62: from hxc_mappings m, hxc_mapping_comp_usages u, hxc_mapping_components c

58: cursor field_name_already
59: (p_id in number
60: ,p_name in varchar2) is
61: select 'Y'
62: from hxc_mappings m, hxc_mapping_comp_usages u, hxc_mapping_components c
63: where m.mapping_id = u.mapping_id
64: and m.name = p_name
65: and u.mapping_component_id = c.mapping_component_id
66: and c.field_name =

Line 216: DELETE from hxc_mapping_comp_usages

212: --
213:
214: for map_rec in c_map_comp(p_info_type_basis) LOOP
215:
216: DELETE from hxc_mapping_comp_usages
217: where mapping_component_id = map_rec.mapping_component_id;
218:
219: end LOOP;
220:

Line 727: from hxc_mapping_comp_usages

723: -- in the where clause.
724:
725: select 'Y'
726: into l_dummy
727: from hxc_mapping_comp_usages
728: where mapping_component_id = p_map_comp_id
729: and rownum =1;
730:
731: return false;