APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TMP_BLD_BLKS

Line 5418: FROM hxc_tmp_bld_blks;

5414:
5415: CURSOR gaz_chk_tmp_table
5416: IS
5417: SELECT 'x'
5418: FROM hxc_tmp_bld_blks;
5419:
5420: CURSOR csr_get_old_detail_bld_blks
5421: IS
5422: SELECT /*+ ORDERED INDEX(TBB) INDEX(DAY) USE_NL(TBB, DAY) */

Line 5440: FROM hxc_tmp_bld_blks tmp,

5436: tbb.SCOPE, tbb.TYPE,
5437: DECODE (tbb.TYPE, 'MEASURE', tbb.unit_of_measure, 'HOURS'),
5438: tbb.date_from, tbb.date_to, tbb.approval_status,
5439: tbb.approval_style_id
5440: FROM hxc_tmp_bld_blks tmp,
5441: hxc_time_building_blocks tbb,
5442: hxc_time_building_blocks DAY
5443: WHERE tbb.time_building_block_id = tmp.time_building_block_id
5444: AND tbb.object_version_number = tmp.time_building_block_ovn

Line 5463: FROM hxc_tmp_bld_blks tmp,

5459: ta.attribute20, ta.attribute21, ta.attribute22,
5460: ta.attribute23, ta.attribute24, ta.attribute25,
5461: ta.attribute26, ta.attribute27, ta.attribute28,
5462: ta.attribute29, ta.attribute30
5463: FROM hxc_tmp_bld_blks tmp,
5464: hxc_time_attribute_usages tau,
5465: hxc_time_attributes ta
5466: WHERE tau.time_building_block_id = tmp.time_building_block_id
5467: AND tau.time_building_block_ovn = tmp.time_building_block_ovn

Line 5697: INSERT INTO hxc_tmp_bld_blks

5693:
5694: WHILE l_lower_range <= t_old_detail_bb_id.LAST
5695: LOOP
5696: FORALL x IN l_lower_range .. l_upper_range
5697: INSERT INTO hxc_tmp_bld_blks
5698: (seq, time_building_block_id,
5699: time_building_block_ovn
5700: )
5701: VALUES (t_old_detail_seq (x), t_old_detail_bb_id (x),

Line 5766: fnd_message.set_name ('HXC', 'HXC_TMP_BLD_BLKS_NOT_TMP');

5762: IF gaz_chk_tmp_table%FOUND
5763: THEN
5764: CLOSE gaz_chk_tmp_table;
5765:
5766: fnd_message.set_name ('HXC', 'HXC_TMP_BLD_BLKS_NOT_TMP');
5767: fnd_message.raise_error;
5768: END IF;
5769:
5770: CLOSE gaz_chk_tmp_table;