2099:
2100: CURSOR cur_get_instance_id (v_instance_no NUMBER, v_resource VARCHAR2)
2101: IS
2102: SELECT instance_id
2103: FROM gmp_resource_instances i, cr_rsrc_dtl r
2104: WHERE r.resource_id = i.resource_id
2105: AND r.resources = v_resource
2106: AND instance_number = v_instance_no;
2107:
2109: v_instance_id NUMBER
2110: ,v_resource VARCHAR2)
2111: IS
2112: SELECT 1
2113: FROM gmp_resource_instances i, cr_rsrc_dtl r
2114: WHERE r.resource_id = i.resource_id
2115: AND r.resources = v_resource
2116: AND instance_id = v_instance_id;
2117: