603:
604: Cursor c_business_process_id (p_business_process_id IN NUMBER) IS
605:
606: SELECT business_process_id
607: FROM cs_business_processes
608: WHERE business_process_id = p_business_process_id;
609:
610: lv_exists_flag VARCHAR2(1) := 'N';
611:
14936: NVL(inc.ship_to_contact_id,-999) ship_to_contact_id,
14937: inc.caller_type
14938: FROM cs_incidents_all_b inc,
14939: CS_INCIDENT_TYPES intp,
14940: CS_BUSINESS_PROCESSES bp,
14941: hz_parties hzp,
14942: hz_cust_accounts hza
14943: WHERE inc.incident_id = p_incident_id
14944: AND inc.incident_type_id = intp.incident_type_id