Line 865: FROM csd_repairs_v crv, csd_repair_types_vl crtv
861: WHERE repair_line_id = p_repair_line_id and action_type = 'SHIP';
862:
863: CURSOR c_repair_type_ref(p_repair_line_id IN NUMBER) IS
864: SELECT crtv.repair_type_ref 865: FROM csd_repairs_v crv, csd_repair_types_vl crtv 866: WHERE repair_line_id = p_repair_line_id and crv.repair_type_id = crtv.repair_type_id;
867:
868: CURSOR c_wip_job(p_repair_line_id IN NUMBER) IS
869: SELECT count(*)