APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_MAX_OVN

Line 2177: FROM hxc_max_ovn;

2173: IS
2174: CURSOR csr_get_max_ovn_debug
2175: IS
2176: SELECT time_building_block_id || ':' || max_ovn ovn
2177: FROM hxc_max_ovn;
2178:
2179: -- Bug 13705204
2180: -- Modified the hints below to point to the right indexes.
2181: CURSOR csr_get_max_ovn_rrb (p_retrieval_process_id NUMBER)

Line 2272: DELETE FROM hxc_max_ovn;

2268: hr_utility.TRACE ('Entering populate_max_ovn');
2269: END IF;
2270:
2271: -- clear out the table
2272: DELETE FROM hxc_max_ovn;
2273:
2274: IF (g_params.p_process IN
2275: ('BEE Retrieval Process',
2276: 'Apply Schedule Rules',

Line 2303: INSERT INTO hxc_max_ovn

2299:
2300: IF (t_max_ovn_bb_id.COUNT <> 0)
2301: THEN
2302: FORALL x IN t_max_ovn_bb_id.FIRST .. t_max_ovn_bb_id.LAST
2303: INSERT INTO hxc_max_ovn
2304: (time_building_block_id, max_ovn
2305: )
2306: VALUES (t_max_ovn_bb_id (x), t_max_ovn (x)
2307: );

Line 2339: INSERT INTO hxc_max_ovn

2335:
2336: IF (t_max_ovn_bb_id.COUNT <> 0)
2337: THEN
2338: FORALL x IN t_max_ovn_bb_id.FIRST .. t_max_ovn_bb_id.LAST
2339: INSERT INTO hxc_max_ovn
2340: (time_building_block_id, max_ovn
2341: )
2342: VALUES (t_max_ovn_bb_id (x), t_max_ovn (x)
2343: );

Line 2380: INSERT INTO hxc_max_ovn

2376: hr_utility.TRACE ('inserting');
2377: END IF;
2378:
2379: FORALL x IN t_max_ovn_bb_id.FIRST .. t_max_ovn_bb_id.LAST
2380: INSERT INTO hxc_max_ovn
2381: (time_building_block_id, max_ovn
2382: )
2383: VALUES (t_max_ovn_bb_id (x), t_max_ovn (x)
2384: );

Line 7196: , hxc_max_ovn detail_max_ovn';

7192: , Hxc_time_attribute_usages detail_usage
7193: , Hxc_time_attributes detail_att
7194: , hxc_time_building_blocks day_block
7195: , hxc_time_building_blocks timecard_block
7196: , hxc_max_ovn detail_max_ovn';
7197: l_incremental_from VARCHAR2 (400)
7198: := '
7199: FROM
7200: hxc_retrieval_range_blks tbb

Line 7207: , hxc_max_ovn detail_max_ovn';

7203: , Hxc_time_attributes detail_att
7204: , hxc_time_building_blocks day_block
7205: , hxc_time_building_blocks timecard_block
7206: , hxc_latest_details hld
7207: , hxc_max_ovn detail_max_ovn';
7208: l_time VARCHAR2 (400)
7209: := '
7210: WHERE
7211: timecard_block.scope = ''TIMECARD'' AND

Line 7228: , hxc_max_ovn detail_max_ovn';

7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block
7226: , hxc_time_building_blocks timecard_block
7227: , hxc_pa_latest_details hld
7228: , hxc_max_ovn detail_max_ovn';
7229:
7230: l_incremental_from_pay VARCHAR2 (400)
7231: := '
7232: FROM

Line 7240: , hxc_max_ovn detail_max_ovn';

7236: , Hxc_time_attributes detail_att
7237: , hxc_time_building_blocks day_block
7238: , hxc_time_building_blocks timecard_block
7239: , hxc_pay_latest_details hld
7240: , hxc_max_ovn detail_max_ovn';
7241:
7242:
7243:
7244: l_time_ex VARCHAR2 (560)