DBA Data[Home] [Help]

APPS.CSF_MAINTAIN_GRP dependencies on CSF_UTIL_PVT

Line 744: SUM(NVL(csf_util_pvt.convert_to_minutes(

740:
741: update cac_sr_object_capacity cac set cac.available_hours =
742: ( SELECT (cac.END_DATE_TIME - cac.START_DATE_TIME) -
743: SUM(ta.booking_end_date - ta.booking_start_date) -
744: SUM(NVL(csf_util_pvt.convert_to_minutes(
745: ta.sched_travel_duration
746: , ta.sched_travel_duration_uom
747: ), 0)) /(24*60)
748: FROM jtf_task_assignments ta