APPS.CSD_REPAIRS_PVT dependencies on CSD_REPAIR_TYPES_B

Line 129: FROM csd_repair_types_b b

125: --
126: --rfieldma: 5355051
127: CURSOR c_get_bus_proc_id(p_repair_type_id NUMBER) IS
128: SELECT business_process_id
129: FROM csd_repair_types_b b
130: WHERE repair_type_id = p_repair_type_id;
131:
132: --rfieldma: 5355051
133: CURSOR c_get_severity_id (p_incident_id NUMBER) IS

Line 357: FROM Csd_Repair_types_b

353: -- This is to fix bug 3435292 saupadhy
354: BEGIN
355: SELECT 'Y'
356: INTO l_Refurbish_Non_IO_Order
357: FROM Csd_Repair_types_b
358: WHERE Repair_type_id = l_REPLN_Rec.Repair_type_Id
359: AND repair_type_Ref = 'RF'
360: AND NVL(internal_order_flag,'N') = 'N' ;
361: l_Approval_required_flag := 'N' ;

Line 1450: FROM CSD_REPAIR_TYPES_B TYPE

1446: IS
1447:
1448: CURSOR c1 IS
1449: SELECT 'X'
1450: FROM CSD_REPAIR_TYPES_B TYPE
1451: WHERE TYPE.repair_type_id = p_repair_type_id
1452: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(TYPE.start_date_active, SYSDATE))
1453: AND TRUNC(NVL(TYPE.end_date_active, SYSDATE));
1454:

Line 2412: FROM Csd_REpair_types_b

2408: -- Check if repair Type is Refurbished saupadhy 11.5.10
2409: -- If so set flag l_Refurbihed_repair_Type_Flag with value 'Y'
2410: BEGIN
2411: SELECT 'Y' INTO l_Refurbished_repair_Type_Flag
2412: FROM Csd_REpair_types_b
2413: WHERE Repair_type_Id = p_Repln_Rec.Repair_Type_Id
2414: AND NVL(internal_order_Flag,'N') = 'N'
2415: AND repair_type_ref = 'RF' ;
2416: EXCEPTION