APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_HISTORY

Line 6099: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist

6095:
6096: -- check if this task is saved in the repair history
6097: SELECT COUNT(*)
6098: INTO l_check_task
6099: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist
6100: WHERE tsk.source_object_id = hist.repair_line_id
6101: AND hist.paramn1 = p_task_id
6102: AND tsk.source_object_type_code = 'DR'
6103: AND hist.event_code = 'TC';

Line 6358: FROM CSD_REPAIR_HISTORY hist

6354: hist.paramc3, -- tsk.owner
6355: null paramc4, -- tsk.assignee_type
6356: null paramc5, -- tsk.assignee_name
6357: hist.paramc6 -- tsk.task_status
6358: FROM CSD_REPAIR_HISTORY hist
6359: WHERE hist.paramn1 = p_task_id
6360: AND hist.repair_line_id = p_repair_line_id
6361: --and hist.event_code = 'TC'
6362: ORDER BY hist.repair_history_id DESC;

Line 6393: CSD_REPAIR_HISTORY hist

6389: -- check if this task creation / update is saved in the repair history
6390: SELECT COUNT(*)
6391: INTO l_check_id
6392: FROM CSD_REPAIR_TASKS_V tsk,
6393: CSD_REPAIR_HISTORY hist
6394: WHERE tsk.source_object_id = p_repair_line_id
6395: AND hist.paramn1 = p_task_id
6396: AND tsk.task_id = hist.paramn1
6397: AND tsk.source_object_id = hist.repair_line_id

Line 6692: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist

6688:
6689: -- check if this task is saved in the repair history
6690: SELECT COUNT(*)
6691: INTO l_check_task
6692: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist
6693: WHERE tsk.source_object_id = hist.repair_line_id
6694: AND hist.paramn1 = p_task_activity_rec.task_id
6695: AND tsk.source_object_type_code = 'DR'
6696: AND hist.event_code = 'TC';

Line 6953: FROM CSD_REPAIR_HISTORY hist

6949: hist.paramc6, -- task status/null (TAC)
6950: hist.paramn3, -- task owner id/assignee isd (TAC)
6951: hist.paramn5, --status id/null (TAC)
6952: hist.paramn6 -- tsk.assignee_id (TAC)
6953: FROM CSD_REPAIR_HISTORY hist
6954: WHERE hist.paramn1 = p_task_id
6955: AND hist.repair_line_id = p_repair_line_id
6956: --and hist.event_code = 'TC'
6957: ORDER BY hist.repair_history_id DESC;