DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on CSD_REPAIR_TASKS_V

Line 9034: from csd_repair_tasks_v tsk

9030: CURSOR c_updated_tasks( p_repair_line_id in number ) is
9031: select tsk.task_id
9032: ,rep.repair_line_id
9033: --,max(hist.repair_history_id) repair_history_id
9034: from csd_repair_tasks_v tsk
9035: ,csd_repair_history hist
9036: ,csd_repairs rep
9037: where rep.repair_line_id = tsk.source_object_id
9038: and tsk.source_object_id = hist.repair_line_id

Line 9062: from CSD_REPAIR_TASKS_V tsk

9058: tsk.actual_end_date, -- hist.paramd3
9059: tsk.last_update_date, -- hist.paramd4
9060: hist.paramc3, -- tsk.owner
9061: hist.paramc6 -- tsk.task_status
9062: from CSD_REPAIR_TASKS_V tsk
9063: ,csd_repair_history hist
9064: where tsk.source_object_type_code = 'DR'
9065: and tsk.task_id = l_task_id
9066: and tsk.source_object_id = l_repair_line_id