3143:
3144: CURSOR get_oprn (l_oprn_id NUMBER)
3145: IS
3146: SELECT oprn_no, oprn_vers 3147: FROM gmd_operations_b 3148: WHERE oprn_id = l_oprn_id;
3149:
3150: CURSOR verify_oprn (
3151: l_oprn_no VARCHAR2
Line 3159: FROM gmd_operations_b
3155: SELECT 1
3156: FROM DUAL
3157: WHERE EXISTS (
3158: SELECT 1 3159: FROM gmd_operations_b 3160: WHERE oprn_no = l_oprn_no
3161: AND oprn_vers = l_oprn_vers
3162: AND owner_organization_id = l_org_id);
3163: BEGIN