APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_MAPPINGS

Line 45: hxc_mappings m

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
49: (select c2.mapping_component_id

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 112: from hxc_mappings m

108: ,p_process_name in VARCHAR2) is
109:
110: cursor c_mapping_id(p_mapping_process_name in VARCHAR2) is
111: select mapping_id
112: from hxc_mappings m
113: where m.name = p_mapping_process_name;
114:
115: l_mapping_id HXC_MAPPINGS.MAPPING_ID%TYPE;
116: l_map_comp_usage_id NUMBER;

Line 115: l_mapping_id HXC_MAPPINGS.MAPPING_ID%TYPE;

111: select mapping_id
112: from hxc_mappings m
113: where m.name = p_mapping_process_name;
114:
115: l_mapping_id HXC_MAPPINGS.MAPPING_ID%TYPE;
116: l_map_comp_usage_id NUMBER;
117: l_map_comp_ovn NUMBER;
118:
119: BEGIN