50: l_organization_id number :=null;
51:
52: CURSOR cresid IS
53: SELECT instance_id, instance_number
54: FROM csi_item_instances
55: WHERE equipment_gen_object_id = nvl(p_equipment_gen_object_id, equipment_gen_object_id) ;
56:
57: CURSOR corgid IS
58: SELECT mp.maint_organization_id
55: WHERE equipment_gen_object_id = nvl(p_equipment_gen_object_id, equipment_gen_object_id) ;
56:
57: CURSOR corgid IS
58: SELECT mp.maint_organization_id
59: FROM csi_item_instances cii, mtl_parameters mp
60: WHERE cii.equipment_gen_object_id = nvl(p_equipment_gen_object_id, cii.equipment_gen_object_id) AND
61: p_event_date BETWEEN active_start_date AND
62: NVL(active_end_date, SYSDATE) AND
63: cii.last_vld_organization_id = mp.organization_id;
122: /* For Multiple Record Situation*/
123:
124: BEGIN
125: SELECT 1 INTO l_count
126: FROM csi_item_instances
127: WHERE equipment_gen_object_id = p_equipment_gen_object_id;
128:
129: EXCEPTION
130: WHEN NO_DATA_FOUND THEN