APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_APP_PERIOD_TOTAL_TIME_V
Line 5256: FROM hxc_app_period_total_time_v
5252: l_rounding_rule VARCHAR2(20);
5253:
5254: CURSOR csr_get_total_timecard_hrs IS
5255: SELECT NVL( hours_worked, 0 ) 5256: FROM hxc_app_period_total_time_v 5257: WHERE resource_id = p_resource_id
5258: AND start_date BETWEEN p_period_start_time AND p_period_stop_time
5259: AND stop_date BETWEEN p_period_start_time AND p_period_stop_time
5260: AND application_period_id = p_application_period_id;