DBA Data[Home] [Help]

APPS.CSF_MAINTAIN_GRP dependencies on CSF_UTIL_PVT

Line 643: SUM(NVL(csf_util_pvt.convert_to_minutes(

639:
640: update cac_sr_object_capacity cac set cac.available_hours =
641: ( SELECT (cac.END_DATE_TIME - cac.START_DATE_TIME) -
642: SUM(ta.booking_end_date - ta.booking_start_date) -
643: SUM(NVL(csf_util_pvt.convert_to_minutes(
644: ta.sched_travel_duration
645: , ta.sched_travel_duration_uom
646: ), 0)) /(24*60)
647: FROM jtf_task_assignments ta