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 563: FROM CSD_REPAIRS A, CS_INCIDENTS_ALL_VL B

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

Line 988: FROM CSD_REPAIRS A, CSD_REPAIR_TYPES_B B

984: SELECT A.INCIDENT_ID,
985: A.CONTRACT_LINE_ID,
986: B.BUSINESS_PROCESS_ID,
987: B.REPAIR_TYPE_ID
988: FROM CSD_REPAIRS A, CSD_REPAIR_TYPES_B B
989: WHERE A.REPAIR_LINE_ID = p_repair_line_id
990: AND A.REPAIR_TYPE_ID = B.REPAIR_TYPE_ID;
991:
992: -- Cursor to get the contract_id and contract_number

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

1084: END IF;
1085:
1086: --------------------------------------------------------------------
1087: --Get the business process and incident id values from the
1088: -- CSD_REPAIRS table. Since the repair line id is validated
1089: -- there is no need to check for rec not found condition.
1090: --------------------------------------------------------------------
1091: px_estimate_line_rec.business_process_id := -1;
1092: px_estimate_line_rec.incident_id := -1;