APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_MAX_OVN

Line 1583: FROM hxc_max_ovn;

1579: IS
1580: CURSOR csr_get_max_ovn_debug
1581: IS
1582: SELECT time_building_block_id || ':' || max_ovn ovn
1583: FROM hxc_max_ovn;
1584:
1585: CURSOR csr_get_max_ovn_rrb (p_retrieval_process_id NUMBER)
1586: IS
1587: SELECT /*+ ORDERED INDEX(TXD) INDEX(TX) USE_NL(TXD, TX) */

Line 1673: DELETE FROM hxc_max_ovn;

1669: hr_utility.TRACE ('Entering populate_max_ovn');
1670: END IF;
1671:
1672: -- clear out the table
1673: DELETE FROM hxc_max_ovn;
1674:
1675: IF (g_params.p_process IN
1676: ('BEE Retrieval Process',
1677: 'Apply Schedule Rules',

Line 1704: INSERT INTO hxc_max_ovn

1700:
1701: IF (t_max_ovn_bb_id.COUNT <> 0)
1702: THEN
1703: FORALL x IN t_max_ovn_bb_id.FIRST .. t_max_ovn_bb_id.LAST
1704: INSERT INTO hxc_max_ovn
1705: (time_building_block_id, max_ovn
1706: )
1707: VALUES (t_max_ovn_bb_id (x), t_max_ovn (x)
1708: );

Line 1740: INSERT INTO hxc_max_ovn

1736:
1737: IF (t_max_ovn_bb_id.COUNT <> 0)
1738: THEN
1739: FORALL x IN t_max_ovn_bb_id.FIRST .. t_max_ovn_bb_id.LAST
1740: INSERT INTO hxc_max_ovn
1741: (time_building_block_id, max_ovn
1742: )
1743: VALUES (t_max_ovn_bb_id (x), t_max_ovn (x)
1744: );

Line 1781: INSERT INTO hxc_max_ovn

1777: hr_utility.TRACE ('inserting');
1778: END IF;
1779:
1780: FORALL x IN t_max_ovn_bb_id.FIRST .. t_max_ovn_bb_id.LAST
1781: INSERT INTO hxc_max_ovn
1782: (time_building_block_id, max_ovn
1783: )
1784: VALUES (t_max_ovn_bb_id (x), t_max_ovn (x)
1785: );

Line 6356: , hxc_max_ovn detail_max_ovn';

6352: , Hxc_time_attribute_usages detail_usage
6353: , Hxc_time_attributes detail_att
6354: , hxc_time_building_blocks day_block
6355: , hxc_time_building_blocks timecard_block
6356: , hxc_max_ovn detail_max_ovn';
6357: l_incremental_from VARCHAR2 (400)
6358: := '
6359: FROM
6360: hxc_retrieval_range_blks tbb

Line 6367: , hxc_max_ovn detail_max_ovn';

6363: , Hxc_time_attributes detail_att
6364: , hxc_time_building_blocks day_block
6365: , hxc_time_building_blocks timecard_block
6366: , hxc_latest_details hld
6367: , hxc_max_ovn detail_max_ovn';
6368: l_time VARCHAR2 (400)
6369: := '
6370: WHERE
6371: timecard_block.scope = ''TIMECARD'' AND