[Home] [Help]
50: CURSOR c_get_trx_date (c_book_type_code varchar2,
51: c_period_counter number) IS
52: SELECT cp.start_date
53: FROM fa_calendar_periods cp
54: , fa_calendar_types ct
55: , fa_fiscal_year fy
56: , fa_book_controls bc
57: WHERE bc.book_type_code = c_book_type_code
58: AND ct.calendar_type = bc.deprn_calendar