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 263: FROM okc_k_lines_v a,

259: AND a.id = c.cle_id
260: UNION
261: SELECT c.object1_id1,
262: c.OBJECT1_ID2 --21-Oct-2011 sechawla Bug 12888543 : added to get the inventory org id
263: FROM okc_k_lines_v a,
264: okc_line_styles_v b,
265: okc_k_items c
266: WHERE a.id = p_cle_id
267: AND a.lse_id = b.id