APPS.CSF_MAINTAIN_GRP dependencies on CAC_SR_OBJECT_CAPACITY

Line 605: delete cac_sr_object_capacity

601: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');
603: END IF;
604:
605: delete cac_sr_object_capacity
606: where object_capacity_id in
607: (select cac.object_capacity_id
608: from
609: cac_sr_object_capacity cac

Line 609: cac_sr_object_capacity cac

605: delete cac_sr_object_capacity
606: where object_capacity_id in
607: (select cac.object_capacity_id
608: from
609: cac_sr_object_capacity cac
610: , JTF_TASKS_B tskt
611: , JTF_OBJECT_PURGE_PARAM_TMP tmp
612: , jtf_Task_assignments jtt
613: , jtf_task_statuses_b jtfts

Line 640: update cac_sr_object_capacity cac set cac.available_hours =

636: );
637:
638:
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

Line 654: cac_sr_object_capacity cac

650: where cac.start_date_time > sysdate and
651: cac.object_capacity_id in
652: (select cac.object_capacity_id
653: from
654: cac_sr_object_capacity cac
655: , JTF_TASKS_B tskt
656: , JTF_OBJECT_PURGE_PARAM_TMP tmp
657: , jtf_Task_assignments jtt
658: , jtf_task_statuses_b jtfts