APPS.HXC_MAPPING_UTILITIES dependencies on HXC_RETRIEVAL_PROCESSES

Line 1989: , hxc_retrieval_processes hrp

1985: select distinct hmc.segment, hit.bld_blk_info_type
1986: from hxc_mapping_components hmc
1987: , hxc_mapping_comp_usages hmu
1988: , hxc_mappings hmp
1989: , hxc_retrieval_processes hrp
1990: , hxc_bld_blk_info_types hit
1991: where hmu.mapping_id = hmp.mapping_id
1992: and hmp.mapping_id = hrp.mapping_id
1993: and hmc.bld_blk_info_type_id = hit.bld_blk_info_type_id

Line 2156: l_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;

2152: l_field_name_inner varchar2(1000);
2153: l_field_value_inner varchar2(1000);
2154: l_segment_inner hxc_mapping_components.segment%TYPE;
2155:
2156: l_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
2157:
2158: l_query VARCHAR2(8000);
2159:
2160: l_status_list varchar2(400);

Line 2202: FROM hxc_retrieval_processes ret

2198:
2199:
2200: CURSOR csr_get_ret_id IS
2201: SELECT ret.retrieval_process_id
2202: FROM hxc_retrieval_processes ret
2203: WHERE ret.name = p_retrieval_process_name;
2204:
2205: -- Bug 12410558
2206: -- Needed these to fix the regression in the prev fix.