[Home] [Help]
4469: and start_date <= l_transaction_date_entered
4470: and end_date >= l_transaction_date_entered;
4471:
4472: select period_num into h_trans_period_num
4473: from fa_calendar_periods
4474: where calendar_type = h_calendar_type
4475: and start_date <= l_transaction_date_entered
4476: and end_date >= l_transaction_date_entered;
4477:
6442: cursor GET_LAST_TRANS_ID(p_member_asset_id number, p_trans_id number) is
6443: select TH.TRANSACTION_HEADER_ID
6444: from FA_TRANSACTION_HEADERS TH,
6445: FA_TRANSACTION_HEADERS TH1,
6446: FA_CALENDAR_PERIODS DP,
6447: FA_FISCAL_YEAR FY
6448: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6449: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6450: and TH.asset_id = p_member_asset_id
6542: end if;
6543:
6544: select DP.end_date into h_transaction_date
6545: from FA_FISCAL_YEAR FY,
6546: FA_CALENDAR_PERIODS DP
6547: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6548: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6549: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6550: and FY.fiscal_year = p_fiscal_year
6820: end if;
6821:
6822: select DP.end_date into h_transaction_date
6823: from FA_FISCAL_YEAR FY,
6824: FA_CALENDAR_PERIODS DP
6825: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6826: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6827: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6828: and FY.fiscal_year = p_fiscal_year
7154: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is
7155: select TH.TRANSACTION_HEADER_ID
7156: from FA_TRANSACTION_HEADERS TH,
7157: FA_FISCAL_YEAR FY,
7158: FA_CALENDAR_PERIODS DP
7159: where DP.calendar_type = h_calendar_type
7160: and DP.period_num = p_period_num
7161: and FY.fiscal_year_name = h_fiscal_year_name
7162: and FY.fiscal_year = p_fiscal_year
7215: and bk.depreciate_flag = 'YES'
7216: and exists
7217: (select TH1.TRANSACTION_HEADER_ID
7218: from FA_TRANSACTION_HEADERS TH1,
7219: FA_CALENDAR_PERIODS DP1,
7220: FA_FISCAL_YEAR FY
7221: where TH1.book_type_code = BK.book_type_code
7222: and DP1.calendar_type = h_calendar_type
7223: and DP1.period_num = p_period_num
7240: and bk.set_of_books_id = h_set_of_books_id
7241: and exists
7242: (select TH1.TRANSACTION_HEADER_ID
7243: from FA_TRANSACTION_HEADERS TH1,
7244: FA_CALENDAR_PERIODS DP1,
7245: FA_FISCAL_YEAR FY
7246: where TH1.book_type_code = BK.book_type_code
7247: and DP1.calendar_type = h_calendar_type
7248: and DP1.period_num = p_period_num
8550: cursor GET_FY_PERDNUM(p_date date) is
8551: select FY.fiscal_year,
8552: DP.period_num
8553: from fa_fiscal_year FY,
8554: fa_calendar_periods DP
8555: where FY.fiscal_year_name = h_fiscal_year_name
8556: and DP.calendar_type = h_deprn_calendar
8557: and DP.end_date <= FY.end_date
8558: and p_date >= DP.start_date
8585: over (partition by bk_in.asset_id, bk_in.book_type_code
8586: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8587: from fa_books bk_in,
8588: FA_TRANSACTION_HEADERS TH1,
8589: FA_CALENDAR_PERIODS DP1,
8590: FA_FISCAL_YEAR FY
8591: where TH1.book_type_code = BK_in.book_type_code
8592: and DP1.calendar_type = h_deprn_calendar
8593: and DP1.period_num = p_period_num
8607: over (partition by bk_in.asset_id, bk_in.book_type_code
8608: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8609: from fa_books bk_in,
8610: FA_TRANSACTION_HEADERS TH1,
8611: FA_CALENDAR_PERIODS DP1,
8612: FA_FISCAL_YEAR FY
8613: where TH1.book_type_code = BK_in.book_type_code
8614: and DP1.calendar_type = h_deprn_calendar
8615: and DP1.period_num = p_period_num
8625: (
8626: select distinct bk_in2.asset_id, bk_in2.book_type_code
8627: from fa_books bk_in2,
8628: FA_TRANSACTION_HEADERS TH2,
8629: FA_CALENDAR_PERIODS DP2,
8630: FA_FISCAL_YEAR FY2
8631: where TH2.book_type_code = BK_in2.book_type_code
8632: and DP2.calendar_type = h_deprn_calendar
8633: and DP2.period_num = p_period_num
8665: over (partition by bk_in.asset_id, bk_in.book_type_code
8666: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8667: from fa_mc_books bk_in,
8668: FA_TRANSACTION_HEADERS TH1,
8669: FA_CALENDAR_PERIODS DP1,
8670: FA_FISCAL_YEAR FY
8671: where TH1.book_type_code = BK_in.book_type_code
8672: and DP1.calendar_type = h_deprn_calendar
8673: and DP1.period_num = p_period_num
8688: over (partition by bk_in.asset_id, bk_in.book_type_code
8689: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8690: from fa_mc_books bk_in,
8691: FA_TRANSACTION_HEADERS TH1,
8692: FA_CALENDAR_PERIODS DP1,
8693: FA_FISCAL_YEAR FY
8694: where TH1.book_type_code = BK_in.book_type_code
8695: and DP1.calendar_type = h_deprn_calendar
8696: and DP1.period_num = p_period_num
8707: (
8708: select distinct bk_in2.asset_id, bk_in2.book_type_code
8709: from fa_mc_books bk_in2,
8710: FA_TRANSACTION_HEADERS TH2,
8711: FA_CALENDAR_PERIODS DP2,
8712: FA_FISCAL_YEAR FY2
8713: where TH2.book_type_code = BK_in2.book_type_code
8714: and DP2.calendar_type = h_deprn_calendar
8715: and DP2.period_num = p_period_num
8763: --* Get all transaction headers exists in the specified period
8764: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number, p_member_asset_id number) is
8765: select TH.TRANSACTION_HEADER_ID, TH.TRANSACTION_TYPE_CODE,TH.TRANSACTION_KEY --Bug 8484007
8766: from FA_TRANSACTION_HEADERS TH,
8767: FA_CALENDAR_PERIODS DP,
8768: FA_FISCAL_YEAR FY
8769: where DP.calendar_type = h_deprn_calendar
8770: and DP.period_num = p_period_num
8771: and FY.fiscal_year_name = h_fiscal_year_name
11648: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11649:
11650: select cp.period_name
11651: into h_period_name
11652: from fa_calendar_periods cp, fa_fiscal_year fy
11653: where cp.calendar_type = h_calendar_type and
11654: cp.period_num = p_period_num and
11655: cp.start_date >= fy.start_date and
11656: cp.end_date <= fy.end_date and