29: CS_OPEN_TASKS_EXIST exception;
30:
31: CURSOR c_charge_lines IS
32: SELECT incident_id
33: FROM CS_ESTIMATE_DETAILS
34: WHERE incident_id = p_service_request_id
35: AND (charge_line_type = 'IN_PROGRESS'
36: OR (charge_line_type='ACTUAL'
37: AND interface_to_oe_flag = 'Y'
364: WHERE incident_id = c_request_id;
365:
366: CURSOR c_charge_lines IS
367: SELECT incident_id
368: FROM CS_ESTIMATE_DETAILS
369: WHERE incident_id = p_service_request_id
370: AND (charge_line_type = 'IN_PROGRESS'
371: OR (charge_line_type='ACTUAL'
372: AND interface_to_oe_flag = 'Y'