JA India - Income Tax Act Fixed Asset Schedules - draft

select
         a.cost cost  ,
          c.asset_id,
          b.block_id       block_id1,
          d.start_date ,
         d.end_date ,
         d.slno,
         a.transaction_header_id_in ,
a.date_effective,
	JA_JAINYEDE_XMLP_PKG.cf_7formula(c.asset_id, b.block_id) CF_7,
	JA_JAINYEDE_XMLP_PKG.cf_3formula(c.asset_id, b.block_id, a.cost, d.slno, :BLOCK_ID, :RATE, :TYPE1, :OPENING_WDV, :CLOSING_WDV, :DEPN_OF_ASSETS, :TOTAL, :UNPLANNED_DEPN) CF_3,
	JA_JAINYEDE_XMLP_PKG.cf_8formula(a.cost, a.transaction_header_id_in, a.date_effective, c.asset_id) CF_8
from fa_books a,
         JAI_FA_AST_BLOCKS b,
         JAI_FA_AST_BLOCK_DTLS c,
         JAI_FA_AST_PERIOD_RATES d
 where a.asset_id = c.asset_id
     and b.block_id = c.block_id
    and  a.book_type_code = b.book_type_code
     AND A.BOOK_TYPE_CODE = :BOOK_NAME
     and date_of_acquisition between d.start_date  and d.end_date
    and  TO_CHAR(b.start_date,'DD-MON-RRRR') between TO_CHAR(nvl(:start_date_n,b.start_date),'DD-MON-RRRR')   and
           TO_CHAR(nvl(:end_date_n,b.year_ended),'DD-MON-RRRR')
     and TO_CHAR(d.year_start,'DD-MON-RRRR') = TO_CHAR(nvl(:start_date_n,d.year_start),'DD-MON-RRRR')
     and TO_CHAR(d.year_end,'DD-MON-RRRR') =  TO_CHAR(nvl(:end_date_n,d.year_end),'DD-MON-RRRR')
  and A.date_ineffective is  null
   and A.transaction_header_id_out is   null
 and b.block_id=:block_id