DBA Data[Home] [Help]

APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_AE_TMPT_LNES

Line 96: FROM OKL_AE_TMPT_LNES

92: CURSOR get_ae_lines(p_product VARCHAR2, p_stream_type VARCHAR2, p_memo_yn VARCHAR2) IS
93: SELECT code_combination_id,
94: ae_line_type,
95: crd_code
96: FROM OKL_AE_TMPT_LNES
97: WHERE avl_id IN (SELECT avl.id
98: FROM okl_ae_templates avl,okl_trx_types_v try,okl_strm_type_v sty
99: WHERE aes_id IN
100: (SELECT avl.aes_id FROM okl_products_v WHERE avl.name = p_product)

Line 112: FROM OKL_AE_TMPT_LNES

108: --end changed by abhsaxen for Bug#6174484
109: /* SELECT code_combination_id,
110: ae_line_type,
111: crd_code
112: FROM OKL_AE_TMPT_LNES
113: WHERE avl_id IN (SELECT id
114: FROM okl_Ae_templates_uv
115: WHERE aes_id IN
116: (SELECT aes_id FROM okl_products_v WHERE name = p_product)