[Home] [Help]
248: --,l.currency_code func_currency_code -- SECHAWLA 29-JUL-05 4456005 : added
249: --,l.DNZ_KHR_ID -- SECHAWLA 29-JUL-05 4456005 : added
250: -- SGORANTL 22-MAR-06 5097643: changes made by kbbhavsa for bug 4717511 has been reversed
251: ,h.try_id --akrangan added for sla populate sources cr
252: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views
253: WHERE h.id = l.tas_id
254: AND l.id = d.tal_id(+)
255: AND FL.LOOKUP_CODE = h.TAS_TYPE AND FL.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
256: AND decode(d.tax_book,NULL, l.CORPORATE_BOOK,d.tax_book ) = fbc.book_type_code
276: --,l.DNZ_KHR_ID -- SECHAWLA 29-JUL-05 4456005 : added
277: -- SGORANTL 22-MAR-06 5097643: changes made by kbbhavsa for bug 4717511 has been reversed
278: ,h.try_id --akrangan added for sla populate sources cr
279: ,l.id line_id --akrangan added for sla populate sources cr
280: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views
281: WHERE h.id = l.tas_id
282: AND l.id = d.tal_id(+)
283: AND FL.LOOKUP_CODE = h.TAS_TYPE AND FL.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
284: AND decode(d.tax_book,NULL, l.CORPORATE_BOOK,d.tax_book ) = fbc.book_type_code
319: -- This cursor is used to find all the tax books that an asset belongs to
320: /* SECHAWLA 28-DEC-05 4374620 : do not process SVW transactions in tax books
321: CURSOR l_fabookcntrl_csr(p_asset_id IN NUMBER) IS
322: SELECT a.book_type_code
323: FROM fa_books a, fa_book_controls b
324: WHERE a.asset_id = p_asset_id
325: AND a.book_type_code = b.book_type_code
326: AND b.book_class = 'TAX'
327: AND a.date_ineffective IS NULL