APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TMP_BLD_BLKS

Line 6153: FROM hxc_tmp_bld_blks;

6149:
6150: CURSOR gaz_chk_tmp_table
6151: IS
6152: SELECT 'x'
6153: FROM hxc_tmp_bld_blks;
6154:
6155: CURSOR csr_get_old_detail_bld_blks
6156: IS
6157: SELECT /*+ ORDERED INDEX(TBB) INDEX(DAY) USE_NL(TBB, DAY) */

Line 6175: FROM hxc_tmp_bld_blks tmp,

6171: tbb.SCOPE, tbb.TYPE,
6172: DECODE (tbb.TYPE, 'MEASURE', tbb.unit_of_measure, 'HOURS'),
6173: tbb.date_from, tbb.date_to, tbb.approval_status,
6174: tbb.approval_style_id
6175: FROM hxc_tmp_bld_blks tmp,
6176: hxc_time_building_blocks tbb,
6177: hxc_time_building_blocks DAY
6178: WHERE tbb.time_building_block_id = tmp.time_building_block_id
6179: AND tbb.object_version_number = tmp.time_building_block_ovn

Line 6198: FROM hxc_tmp_bld_blks tmp,

6194: ta.attribute20, ta.attribute21, ta.attribute22,
6195: ta.attribute23, ta.attribute24, ta.attribute25,
6196: ta.attribute26, ta.attribute27, ta.attribute28,
6197: ta.attribute29, ta.attribute30
6198: FROM hxc_tmp_bld_blks tmp,
6199: hxc_time_attribute_usages tau,
6200: hxc_time_attributes ta
6201: WHERE tau.time_building_block_id = tmp.time_building_block_id
6202: AND tau.time_building_block_ovn = tmp.time_building_block_ovn

Line 6432: INSERT INTO hxc_tmp_bld_blks

6428:
6429: WHILE l_lower_range <= t_old_detail_bb_id.LAST
6430: LOOP
6431: FORALL x IN l_lower_range .. l_upper_range
6432: INSERT INTO hxc_tmp_bld_blks
6433: (seq, time_building_block_id,
6434: time_building_block_ovn
6435: )
6436: VALUES (t_old_detail_seq (x), t_old_detail_bb_id (x),

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

6497: IF gaz_chk_tmp_table%FOUND
6498: THEN
6499: CLOSE gaz_chk_tmp_table;
6500:
6501: fnd_message.set_name ('HXC', 'HXC_TMP_BLD_BLKS_NOT_TMP');
6502: fnd_message.raise_error;
6503: END IF;
6504:
6505: CLOSE gaz_chk_tmp_table;