3066:
3067: CURSOR get_oprn (l_oprn_id NUMBER)
3068: IS
3069: SELECT oprn_no, oprn_vers 3070: FROM gmd_operations_b 3071: WHERE oprn_id = l_oprn_id;
3072:
3073: CURSOR verify_oprn (
3074: l_oprn_no VARCHAR2
Line 3082: FROM gmd_operations_b
3078: SELECT 1
3079: FROM DUAL
3080: WHERE EXISTS (
3081: SELECT 1 3082: FROM gmd_operations_b 3083: WHERE oprn_no = l_oprn_no
3084: AND oprn_vers = l_oprn_vers
3085: AND owner_organization_id = l_org_id);
3086: BEGIN