APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_BLD_BLK_INFO_TYPE_USAGES

Line 11: building_block_category hxc_bld_blk_info_type_usages.building_block_category%TYPE);

7: (segment hxc_mapping_components.segment%TYPE,
8: field_name hxc_mapping_components.field_name%TYPE,
9: bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE,
10: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
11: building_block_category hxc_bld_blk_info_type_usages.building_block_category%TYPE);
12:
13: TYPE t_mapping IS TABLE OF
14: t_mapping_comp
15: INDEX BY BINARY_INTEGER;

Line 182: ,hxc_bld_blk_info_type_usages bbui

178: ,hxc_mapping_comp_usages mcu
179: ,hxc_mappings m
180: ,hxc_retrieval_processes rp
181: ,hxc_bld_blk_info_types bbit
182: ,hxc_bld_blk_info_type_usages bbui
183: where rp.mapping_id = m.mapping_id
184: and rp.retrieval_process_id = p_retrieval_process_id
185: and m.mapping_id = mcu.mapping_id
186: and mcu.mapping_component_id = mc.mapping_component_id

Line 202: ,hxc_bld_blk_info_type_usages bbui

198: ,hxc_mapping_comp_usages mcu
199: ,hxc_mappings m
200: ,hxc_deposit_processes dp
201: ,hxc_bld_blk_info_types bbit
202: ,hxc_bld_blk_info_type_usages bbui
203: where dp.mapping_id = m.mapping_id
204: and dp.deposit_process_id = p_deposit_process_id
205: and m.mapping_id = mcu.mapping_id
206: and mcu.mapping_component_id = mc.mapping_component_id

Line 1653: hxc_bld_blk_info_type_usages bbui,

1649: mc.field_name,
1650: bbui.building_block_category
1651: FROM
1652: hxc_mapping_components mc,
1653: hxc_bld_blk_info_type_usages bbui,
1654: hxc_bld_blk_info_types bbit
1655: WHERE
1656: mc.mapping_component_id in (Select mcu.mapping_component_id from
1657: hxc_mappings m ,

Line 1678: ,hxc_bld_blk_info_type_usages bbui

1674: ,hxc_mapping_comp_usages mcu
1675: ,hxc_mappings m
1676: ,hxc_deposit_processes dp
1677: ,hxc_bld_blk_info_types bbit
1678: ,hxc_bld_blk_info_type_usages bbui
1679: where dp.mapping_id = m.mapping_id
1680: and dp.deposit_process_id = p_deposit_process_id --AI3
1681: and m.mapping_id = mcu.mapping_id
1682: and mcu.mapping_component_id = mc.mapping_component_id

Line 2690: ,hxc_bld_blk_info_type_usages bbui

2686: ,hxc_mapping_comp_usages mcu
2687: ,hxc_mappings m
2688: ,hxc_retrieval_processes rp
2689: ,hxc_bld_blk_info_types bbit
2690: ,hxc_bld_blk_info_type_usages bbui
2691: where rp.mapping_id = m.mapping_id
2692: AND mc.field_name = p_field_name
2693: and rp.retrieval_process_id = p_retrieval_process_id
2694: and m.mapping_id = mcu.mapping_id