6064: IS
6065:
6066: CURSOR c_clopn_split_csr IS
6067: SELECT id
6068: FROM okc_class_operations
6069: WHERE CLS_CODE = 'SERVICE'
6070: AND OPN_CODE = 'SPLIT';
6071:
6072: l_split_Id NUMBER := NULL;
6721: IS
6722: --select operation id for renewal of 'SERVICE'
6723: CURSOR class_operation_cur IS
6724: SELECT id
6725: FROM okc_class_operations
6726: WHERE opn_code = 'RENEWAL'
6727: AND cls_code = 'SERVICE';
6728:
6729: --select operation instance id for renewal