DBA Data[Home] [Help]

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;