DBA Data[Home] [Help]

APPS.HXC_MPC_BUS dependencies on HXC_BLD_BLK_INFO_TYPES

Line 281: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

277: -- {End Of Comments}
278: -- ----------------------------------------------------------------------------
279: Procedure chk_segment
280: (
281: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
282: , p_segment in hxc_mapping_components.segment%TYPE
283: ) IS
284: --
285: l_proc varchar2(72);

Line 292: , hxc_bld_blk_info_types bbit

288:
289: CURSOR csr_chk_segment IS
290: SELECT 'ok'
291: FROM fnd_descr_flex_column_usages df
292: , hxc_bld_blk_info_types bbit
293: WHERE bbit.bld_blk_info_type_id = p_bld_blk_info_type_id
294: AND df.descriptive_flex_context_code= bbit.bld_blk_info_type
295: AND df.application_id = 809
296: AND df.application_column_name = p_segment;