DBA Data[Home] [Help]

APPS.HXC_MAPPING_UTILITIES dependencies on HXC_MAPPINGS

Line 66: p_mapping_id hxc_mappings.mapping_id%TYPE )

62: -- Declare mapping changed local functions
63: -- ****************************************
64:
65: FUNCTION get_field_mappings (
66: p_mapping_id hxc_mappings.mapping_id%TYPE )
67: RETURN hxc_generic_retrieval_pkg.t_field_mappings
68: IS
69: --
70: l_mapping_record hxc_generic_retrieval_pkg.r_field_mappings;

Line 85: , hxc_mappings map

81: hxc_bld_blk_info_type_usages bbitu
82: , hxc_bld_blk_info_types bbit
83: , hxc_mapping_components mpc
84: , hxc_mapping_comp_usages mcu
85: , hxc_mappings map
86: WHERE map.mapping_id = p_mapping_id
87: AND
88: mcu.mapping_id = map.mapping_id
89: AND

Line 1988: , hxc_mappings hmp

1984: cursor c_map_ret is
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

Line 2002: , hxc_mappings hmp

1998: cursor c_map_dep is
1999: select distinct hmc.segment, hit.bld_blk_info_type
2000: from hxc_mapping_components hmc
2001: , hxc_mapping_comp_usages hmu
2002: , hxc_mappings hmp
2003: , hxc_deposit_processes hdp
2004: , hxc_bld_blk_info_types hit
2005: where hmu.mapping_id = hmp.mapping_id
2006: and hmp.mapping_id = hdp.mapping_id