APPS.CSF_PLANBOARD_TASKS dependencies on CSF_TASKS_PUB

Line 342: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)

338: AND NVL(t.deleted_flag, 'N') <> 'Y'
339: AND t.task_status_id = ts2.task_status_id
340: AND nvl(ts2.cancelled_flag,'N') <> 'Y'
341: AND t.task_type_id = tt.task_type_id
342: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
343: ORDER BY res.resource_name
344: , nvl(a.actual_start_date,t.scheduled_start_date)
345: , DECODE(t.task_type_id, 20, 1, 21, 3, 2)
346: , a.task_assignment_id;

Line 727: IF csf_tasks_pub.is_task_escalated(task_id(i)) THEN

723:
724: -- row #1
725: ---------
726: -- escalated
727: IF csf_tasks_pub.is_task_escalated(task_id(i)) THEN
728: l_cell := '!! ';
729: ELSE
730: l_cell := NULL;
731: END IF;