APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKC_K_LINES_V

Line 112: from OKC_K_LINES_V cle

108: AND tap.try_id = try.id;
109:
110: CURSOR get_top_line_name ( p_cle_id NUMBER ) IS
111: select cle.name
112: from OKC_K_LINES_V cle
113: where cle.id = p_cle_id;
114:
115: CURSOR c_stream_type_purpose (p_sty_id NUMBER ) IS
116: select stream_type_purpose

Line 120: l_asset_number OKC_K_LINES_V.name%type;

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;
122: l_sty_id OKL_STRM_TYPE_B.id%type;
123:
124: --end:| 19-Jun-2007 cklee -- 1. Revert Tax call back |

Line 261: FROM okc_k_lines_v a,

257: AND b.lty_code = 'ITEM'
258: AND a.id = c.cle_id
259: UNION
260: SELECT c.object1_id1
261: FROM okc_k_lines_v a,
262: okc_line_styles_v b,
263: okc_k_items c
264: WHERE a.id = p_cle_id
265: AND a.lse_id = b.id