DBA Data[Home] [Help]

APPS.CSF_TRIPS_PUB dependencies on CSF_UTIL_PVT

Line 709: , csf_util_pvt.convert_to_minutes(

705: , ta.object_version_number
706: , ta.task_id
707: , ta.booking_start_date
708: , ta.booking_end_date
709: , csf_util_pvt.convert_to_minutes(
710: ta.sched_travel_duration
711: , ta.sched_travel_duration_uom
712: ) travel_time
713: FROM jtf_task_assignments ta

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

1353: AND t.task_id = ta.task_id;
1354:
1355: CURSOR c_used_time IS
1356: SELECT SUM (ta.booking_end_date - ta.booking_start_date) used_time
1357: , SUM (NVL(csf_util_pvt.convert_to_minutes(
1358: ta.sched_travel_duration
1359: , ta.sched_travel_duration_uom
1360: ), 0)) travel_time
1361: FROM jtf_task_assignments ta

Line 1744: , csf_util_pvt.convert_to_minutes(

1740: , ta.object_capacity_id
1741: , ta.task_id
1742: , ta.booking_start_date
1743: , ta.booking_end_date
1744: , csf_util_pvt.convert_to_minutes(
1745: ta.sched_travel_duration
1746: , ta.sched_travel_duration_uom
1747: ) travel_time
1748: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc

Line 4082: , csf_util_pvt.convert_to_minutes(

4078: , ta.object_version_number
4079: , ta.task_id
4080: , ta.booking_start_date
4081: , ta.booking_end_date
4082: , csf_util_pvt.convert_to_minutes(
4083: ta.sched_travel_duration
4084: , ta.sched_travel_duration_uom
4085: ) travel_time
4086: FROM jtf_task_assignments ta

Line 5187: , csf_util_pvt.convert_to_minutes(

5183: , ta.task_id
5184: , ta.booking_start_date
5185: , ta.booking_end_date
5186: , ta.object_capacity_id
5187: , csf_util_pvt.convert_to_minutes(
5188: ta.sched_travel_duration
5189: , ta.sched_travel_duration_uom
5190: ) travel_time
5191: FROM jtf_task_assignments ta