DBA Data[Home] [Help]

APPS.CSF_TRIPS_PUB dependencies on CSF_UTIL_PVT

Line 632: , csf_util_pvt.convert_to_minutes(

628: , ta.object_version_number
629: , ta.task_id
630: , ta.booking_start_date
631: , ta.booking_end_date
632: , csf_util_pvt.convert_to_minutes(
633: ta.sched_travel_duration
634: , ta.sched_travel_duration_uom
635: ) travel_time
636: FROM jtf_task_assignments ta

Line 1246: , SUM (NVL(csf_util_pvt.convert_to_minutes(

1242: AND t.task_id = ta.task_id;
1243:
1244: CURSOR c_used_time IS
1245: SELECT SUM (ta.booking_end_date - ta.booking_start_date) used_time
1246: , SUM (NVL(csf_util_pvt.convert_to_minutes(
1247: ta.sched_travel_duration
1248: , ta.sched_travel_duration_uom
1249: ), 0)) travel_time
1250: FROM jtf_task_assignments ta

Line 1625: , csf_util_pvt.convert_to_minutes(

1621: , ta.object_capacity_id
1622: , ta.task_id
1623: , ta.booking_start_date
1624: , ta.booking_end_date
1625: , csf_util_pvt.convert_to_minutes(
1626: ta.sched_travel_duration
1627: , ta.sched_travel_duration_uom
1628: ) travel_time
1629: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc