APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_AE_TEMPLATES

Line 98: FROM okl_ae_templates avl,okl_trx_types_v try,okl_strm_type_v sty

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)
101: AND try.name = 'Accrual'
102: AND sty.name= p_stream_type

Line 114: FROM okl_Ae_templates_uv

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)
117: AND try_name = 'Accrual'
118: AND sty_name = p_stream_type