DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 2434: hxc_timecard_summary ts,

2430: CURSOR csr_get_total_hrs ( p_start_date DATE, p_end_date DATE) IS
2431: SELECT NVL(SUM(SUM(NVL(hxc_time_category_utils_pkg.category_detail_hrs( tbb_detail.time_building_block_id,
2432: tbb_detail.object_version_number),0)) ),0)
2433: FROM
2434: hxc_timecard_summary ts,
2435: hxc_time_building_blocks tbb_day,
2436: hxc_time_building_blocks tbb_detail
2437: WHERE
2438: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and