251: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED');
252:
253: CURSOR get_operating_unit_csr IS
254: SELECT name
255: FROM hr_operating_units
256: WHERE organization_id = mo_global.get_current_org_id() ;
257: --local variables
258: l_op_unit HR_OPERATING_UNITS.name%type;
259: l_curr_code VARCHAR2(30) DEFAULT NULL;
254: SELECT name
255: FROM hr_operating_units
256: WHERE organization_id = mo_global.get_current_org_id() ;
257: --local variables
258: l_op_unit HR_OPERATING_UNITS.name%type;
259: l_curr_code VARCHAR2(30) DEFAULT NULL;
260: l_request_id NUMBER DEFAULT 0;
261: l_cont_id OKC_K_HEADERS_B.id%TYPE DEFAULT NULL;
262: l_asset_id OKX_ASSET_LINES_V.id1%TYPE DEFAULT NULL;