APPS.CSD_ESTIMATE_UTILS_PVT dependencies on CSD_REPAIRS

Line 431: FROM csd_repairs

427: l_C_STATUS_CLOSED VARCHAR2(1) := 'C';
428:
429: CURSOR c1 IS
430: SELECT 'x' col1
431: FROM csd_repairs
432: WHERE repair_line_id = p_repair_line_id
433: AND status <> l_C_STATUS_CLOSED;
434:
435: l_dummy VARCHAR2(1);

Line 561: FROM CSD_REPAIRS A, CS_INCIDENTS_ALL_VL B

557: -- Cursor to get the object version number and repair quantity
558: -- and SR summary
559: CURSOR CUR_REPAIR_LINE(p_Repair_line_id NUMBER) IS
560: SELECT A.QUANTITY, A.OBJECT_VERSION_NUMBER, B.SUMMARY, B.INCIDENT_ID
561: FROM CSD_REPAIRS A, CS_INCIDENTS_ALL_VL B
562: WHERE A.REPAIR_LINE_ID = p_repair_line_id
563: AND A.INCIDENT_ID = B.INCIDENT_ID;
564:
565: l_incident_id NUMBER;

Line 963: FROM CSD_REPAIRS A, CSD_REPAIR_TYPES_B B

959: SELECT A.INCIDENT_ID,
960: A.CONTRACT_LINE_ID,
961: B.BUSINESS_PROCESS_ID,
962: B.REPAIR_TYPE_ID
963: FROM CSD_REPAIRS A, CSD_REPAIR_TYPES_B B
964: WHERE A.REPAIR_LINE_ID = p_repair_line_id
965: AND A.REPAIR_TYPE_ID = B.REPAIR_TYPE_ID;
966:
967: -- Cursor to get the contract_id and contract_number

Line 1063: -- CSD_REPAIRS table. Since the repair line id is validated

1059: END IF;
1060:
1061: --------------------------------------------------------------------
1062: --Get the business process and incident id values from the
1063: -- CSD_REPAIRS table. Since the repair line id is validated
1064: -- there is no need to check for rec not found condition.
1065: --------------------------------------------------------------------
1066: px_estimate_line_rec.business_process_id := -1;
1067: px_estimate_line_rec.incident_id := -1;