[Home] [Help]
395:
396:
397: CURSOR fiscal_period_cur (l_book_type_code IN VARCHAR) IS
398: SELECT start_date
399: FROM fa_book_controls fbc,
400: fa_calendar_periods fcp
401: WHERE fbc.book_type_code = l_book_type_code
402: AND fcp.calendar_type = fbc.deprn_calendar
403: AND trunc(l_transaction_date) BETWEEN fcp.start_date AND fcp.end_date;
606: l_error_message varchar2(2000);
607:
608: CURSOR fab_control_cur (c_book_type_code IN VARCHAR2) IS
609: SELECT accounting_flex_structure
610: FROM fa_book_controls
611: WHERE book_type_code = c_book_type_code ;
612:
613: CURSOR fifs_acct_cur (l_flex_num IN NUMBER) IS
614: SELECT fifs.segment_num
1959: bc.deprn_calendar
1960: from fa_deprn_periods dp,
1961: fa_deprn_periods dp2,
1962: fa_deprn_periods dp3,
1963: fa_book_controls bc
1964: where dp.book_type_code =c_book_type_code
1965: and dp.period_close_date is null
1966: and dp2.book_type_code(+) = bc.distribution_source_book
1967: and dp2.period_counter(+) = bc.last_mass_copy_period_counter
1971:
1972: CURSOR c_dep_date (c_calendar_type in varchar, c_book_type_code IN varchar, c_period_name in varchar) IS
1973: SELECT END_DATE
1974: FROM FA_CALENDAR_PERIODS FAP,
1975: fa_book_controls FAC
1976: WHERE FAP.calendAr_type=c_calendar_type
1977: AND FAC.BOOk_TYPE_CODE =c_book_type_code
1978: AND FAP.PERIOD_NAME=c_period_name;
1979:
2656: CURSOR check_current_period_add
2657: IS
2658: SELECT 'N'
2659: FROM fa_transaction_headers th,
2660: fa_book_controls bc,
2661: fa_deprn_periods dp
2662: WHERE th.asset_id = p_asset_id
2663: AND th.book_type_code = p_book_type_code
2664: AND bc.book_type_code = th.book_type_code
2743: BEGIN
2744:
2745: SELECT fcp.period_name
2746: INTO l_period_name
2747: FROM fa_book_controls fbc,
2748: fa_calendar_periods fcp
2749: WHERE fbc.book_type_code = p_book_type_code
2750: AND fcp.calendar_type = fbc.deprn_calendar
2751: AND p_dpis BETWEEN fcp.start_date AND fcp.end_date;