1078: ----Define Cursors
1079: CURSOR cur_cust_details (p_incident_id IN NUMBER)
1080: IS
1081: SELECT customer_id, account_id
1082: FROM cs_incidents_all_b
1083: WHERE incident_id = p_incident_id;
1084:
1085: /*** contract rearch changes for R12
1086:
1425: END IF;
1426: ****************/
1427:
1428: ---------------------------------------------------------------------------------5
1429: --Get Party_ID and Account_ID from cs_incidents_all_b table for the given incident_Id. If the party_id is null raise error.
1430: IF l_incident_id IS NOT NULL
1431: THEN
1432: OPEN cur_cust_details (l_incident_id);
1433: