[Home] [Help]
351:
352:
353: CURSOR fiscal_period_cur (l_book_type_code IN VARCHAR) IS
354: SELECT start_date
355: FROM fa_book_controls fbc,
356: fa_calendar_periods fcp
357: WHERE fbc.book_type_code = l_book_type_code
358: AND fcp.calendar_type = fbc.deprn_calendar
359: AND trunc(l_transaction_date) BETWEEN fcp.start_date AND fcp.end_date;
562: l_error_message varchar2(2000);
563:
564: CURSOR fab_control_cur (c_book_type_code IN VARCHAR2) IS
565: SELECT accounting_flex_structure
566: FROM fa_book_controls
567: WHERE book_type_code = c_book_type_code ;
568:
569: CURSOR fifs_acct_cur (l_flex_num IN NUMBER) IS
570: SELECT fifs.segment_num
1769: bc.deprn_calendar
1770: from fa_deprn_periods dp,
1771: fa_deprn_periods dp2,
1772: fa_deprn_periods dp3,
1773: fa_book_controls bc
1774: where dp.book_type_code =c_book_type_code
1775: and dp.period_close_date is null
1776: and dp2.book_type_code(+) = bc.distribution_source_book
1777: and dp2.period_counter(+) = bc.last_mass_copy_period_counter
1781:
1782: CURSOR c_dep_date (c_calendar_type in varchar, c_book_type_code IN varchar, c_period_name in varchar) IS
1783: SELECT END_DATE
1784: FROM FA_CALENDAR_PERIODS FAP,
1785: fa_book_controls FAC
1786: WHERE FAP.calendAr_type=c_calendar_type
1787: AND FAC.BOOk_TYPE_CODE =c_book_type_code
1788: AND FAP.PERIOD_NAME=c_period_name;
1789:
2392: CURSOR check_current_period_add
2393: IS
2394: SELECT 'N'
2395: FROM fa_transaction_headers th,
2396: fa_book_controls bc,
2397: fa_deprn_periods dp
2398: WHERE th.asset_id = p_asset_id
2399: AND th.book_type_code = p_book_type_code
2400: AND bc.book_type_code = th.book_type_code
2479: BEGIN
2480:
2481: SELECT fcp.period_name
2482: INTO l_period_name
2483: FROM fa_book_controls fbc,
2484: fa_calendar_periods fcp
2485: WHERE fbc.book_type_code = p_book_type_code
2486: AND fcp.calendar_type = fbc.deprn_calendar
2487: AND p_dpis BETWEEN fcp.start_date AND fcp.end_date;