APPS.CSD_REPAIRS_PVT dependencies on CSD_REPAIR_TYPES_B

Line 137: FROM csd_repair_types_b b

133: --
134: --rfieldma: 5355051
135: CURSOR c_get_bus_proc_id(p_repair_type_id NUMBER) IS
136: SELECT business_process_id, res_dt_calc_point
137: FROM csd_repair_types_b b
138: WHERE repair_type_id = p_repair_type_id;
139:
140: --rfieldma: 5355051
141: CURSOR c_get_severity_id (p_incident_id NUMBER) IS

Line 384: FROM Csd_Repair_types_b

380: -- This is to fix bug 3435292 saupadhy
381: BEGIN
382: SELECT 'Y'
383: INTO l_Refurbish_Non_IO_Order
384: FROM Csd_Repair_types_b
385: WHERE Repair_type_id = l_REPLN_Rec.Repair_type_Id
386: AND repair_type_Ref = 'RF'
387: AND NVL(internal_order_flag,'N') = 'N' ;
388: l_Approval_required_flag := 'N' ;

Line 1757: FROM CSD_REPAIR_TYPES_B TYPE

1753: IS
1754:
1755: CURSOR c1 IS
1756: SELECT 'X'
1757: FROM CSD_REPAIR_TYPES_B TYPE
1758: WHERE TYPE.repair_type_id = p_repair_type_id
1759: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(TYPE.start_date_active, SYSDATE))
1760: AND TRUNC(NVL(TYPE.end_date_active, SYSDATE));
1761:

Line 2720: FROM Csd_REpair_types_b

2716: -- Check if repair Type is Refurbished saupadhy 11.5.10
2717: -- If so set flag l_Refurbihed_repair_Type_Flag with value 'Y'
2718: BEGIN
2719: SELECT 'Y' INTO l_Refurbished_repair_Type_Flag
2720: FROM Csd_REpair_types_b
2721: WHERE Repair_type_Id = p_Repln_Rec.Repair_Type_Id
2722: AND NVL(internal_order_Flag,'N') = 'N'
2723: AND repair_type_ref = 'RF' ;
2724: EXCEPTION