[Home] [Help]
1006: BEGIN
1007:
1008: SELECT 1
1009: INTO x_same_period
1010: FROM fa_calendar_periods fcp, fa_book_controls fbc
1011: WHERE fbc.book_type_code = p_asset_hdr_rec.book_type_code
1012: AND fcp.calendar_type = fbc.deprn_calendar
1013: AND p_trans_rec.transaction_date_entered BETWEEN
1014: fcp.start_date AND fcp.end_date
1319: -- Check that prorate date is defined for given dpis.
1320: begin
1321: select 'x'
1322: into l_check_prorate_date
1323: from fa_calendar_periods cp,
1324: fa_book_controls bc
1325: where bc.book_type_code = p_book_type_code
1326: and bc.prorate_calendar = cp.calendar_type
1327: and l_prorate_date between cp.start_date and cp.end_date;
4612: is
4613: select fcp.end_date
4614: from fa_fiscal_year ffy
4615: ,fa_book_controls fbc
4616: ,fa_calendar_periods fcp
4617: ,fa_calendar_types fct
4618: where ffy.fiscal_year_name = fbc.fiscal_year_name
4619: and ffy.fiscal_year_name = fct.fiscal_year_name
4620: and fbc.book_type_code = p_book_type_code
4721: p_period_ctr in number) is
4722: select fcp.end_date
4723: from fa_fiscal_year ffy
4724: ,fa_book_controls fbc
4725: ,fa_calendar_periods fcp
4726: ,fa_calendar_types fct
4727: where ffy.fiscal_year_name = fbc.fiscal_year_name
4728: and ffy.fiscal_year_name = fct.fiscal_year_name
4729: and fbc.book_type_code = p_book_type_code
4828: is
4829: select fcp.end_date
4830: from fa_fiscal_year ffy
4831: ,fa_book_controls fbc
4832: ,fa_calendar_periods fcp
4833: ,fa_calendar_types fct
4834: where ffy.fiscal_year_name = fbc.fiscal_year_name
4835: and ffy.fiscal_year_name = fct.fiscal_year_name
4836: and fbc.book_type_code = p_book_type_code
6002: ,fcp.period_num
6003: ,fct.number_per_fiscal_year
6004: from fa_fiscal_year ffy
6005: ,fa_book_controls fbc
6006: ,fa_calendar_periods fcp
6007: ,fa_calendar_types fct
6008: where ffy.fiscal_year_name = fbc.fiscal_year_name
6009: and ffy.fiscal_year_name = fct.fiscal_year_name
6010: and fbc.book_type_code = p_book_type_code