APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_FAN_SEQ

Line 4013: SELECT 'OKL'||TO_CHAR(okl_fan_seq.NEXTVAL)

4009: j := j+1;
4010: LOOP
4011: --dbms_output.put_line('Into asset number gen loop');
4012: --dbms_output.put_line('Asset Number'||p_ast_line_rec.asset_number||'.'||to_char(j));
4013: SELECT 'OKL'||TO_CHAR(okl_fan_seq.NEXTVAL)
4014: INTO l_txdv_rec.asset_number FROM dual;
4015: --dbms_output.put_line('Asset Number'||l_txdv_rec.asset_number);
4016: x_return_status := Asset_Number_Exists(l_txdv_rec.asset_number,l_asset_exists);
4017: --dbms_output.put_line('after asset number validate'||x_return_status);