DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 2489: hxc_timecard_summary ts,

2485: CURSOR csr_get_total_hrs ( p_start_date DATE, p_end_date DATE) IS
2486: SELECT NVL(SUM(SUM(NVL(hxc_time_category_utils_pkg.category_detail_hrs( tbb_detail.time_building_block_id,
2487: tbb_detail.object_version_number),0)) ),0)
2488: FROM
2489: hxc_timecard_summary ts,
2490: hxc_time_building_blocks tbb_day,
2491: hxc_time_building_blocks tbb_detail
2492: WHERE
2493: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and