113: where cle.id = p_cle_id;
114:
115: CURSOR c_stream_type_purpose (p_sty_id NUMBER ) IS
116: select stream_type_purpose
117: from OKL_STRM_TYPE_B
118: where id = p_sty_id;
119:
120: l_asset_number OKC_K_LINES_V.name%type;
121: l_stream_type_purpose OKL_STRM_TYPE_B.stream_type_purpose%type;
117: from OKL_STRM_TYPE_B
118: where id = p_sty_id;
119:
120: l_asset_number OKC_K_LINES_V.name%type;
121: l_stream_type_purpose OKL_STRM_TYPE_B.stream_type_purpose%type;
122: l_sty_id OKL_STRM_TYPE_B.id%type;
123:
124: --end:| 19-Jun-2007 cklee -- 1. Revert Tax call back |
125: --| 2. Fixed try_id, kle_id issues |
118: where id = p_sty_id;
119:
120: l_asset_number OKC_K_LINES_V.name%type;
121: l_stream_type_purpose OKL_STRM_TYPE_B.stream_type_purpose%type;
122: l_sty_id OKL_STRM_TYPE_B.id%type;
123:
124: --end:| 19-Jun-2007 cklee -- 1. Revert Tax call back |
125: --| 2. Fixed try_id, kle_id issues |
126: