5450: IS
5451:
5452: CURSOR c_clopn_split_csr IS
5453: SELECT id
5454: FROM okc_class_operations
5455: WHERE CLS_CODE = 'SERVICE'
5456: AND OPN_CODE = 'SPLIT';
5457:
5458: l_split_Id NUMBER := NULL;
6101: IS
6102: --select operation id for renewal of 'SERVICE'
6103: CURSOR class_operation_cur IS
6104: SELECT id
6105: FROM okc_class_operations
6106: WHERE opn_code = 'RENEWAL'
6107: AND cls_code = 'SERVICE';
6108:
6109: --select operation instance id for renewal