2045: x_order_rec Csd_Process_Pvt.om_interface_rec;
2046:
2047: CURSOR cur_order_rec(p_incident_id IN NUMBER) IS
2048: SELECT customer_id, account_id
2049: FROM cs_incidents_all_b
2050: WHERE incident_id = p_incident_id;
2051:
2052: BEGIN
2053:
2649:
2650: -- swai: bug 6001057
2651: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2652: SELECT account_id
2653: FROM cs_incidents_all_b cs, csd_repairs csd
2654: WHERE cs.incident_id = csd.incident_id
2655: AND repair_line_id = l_repair_line_id;
2656:
2657:
2959:
2960: -- swai: bug 6001057
2961: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2962: SELECT account_id
2963: FROM cs_incidents_all_b cs, csd_repairs csd
2964: WHERE cs.incident_id = csd.incident_id
2965: AND repair_line_id = l_repair_line_id;
2966:
2967: BEGIN