DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_APP_PERIOD_TOTAL_TIME_V

Line 5139: FROM hxc_app_period_total_time_v

5135: l_rounding_rule VARCHAR2(20);
5136:
5137: CURSOR csr_get_total_timecard_hrs IS
5138: SELECT NVL( hours_worked, 0 )
5139: FROM hxc_app_period_total_time_v
5140: WHERE resource_id = p_resource_id
5141: AND start_date BETWEEN p_period_start_time AND p_period_stop_time
5142: AND stop_date BETWEEN p_period_start_time AND p_period_stop_time
5143: AND application_period_id = p_application_period_id;