[Home] [Help]
4313: and start_date <= l_transaction_date_entered
4314: and end_date >= l_transaction_date_entered;
4315:
4316: select period_num into h_trans_period_num
4317: from fa_calendar_periods
4318: where calendar_type = h_calendar_type
4319: and start_date <= l_transaction_date_entered
4320: and end_date >= l_transaction_date_entered;
4321:
6280: cursor GET_LAST_TRANS_ID(p_member_asset_id number, p_trans_id number) is
6281: select TH.TRANSACTION_HEADER_ID
6282: from FA_TRANSACTION_HEADERS TH,
6283: FA_TRANSACTION_HEADERS TH1,
6284: FA_CALENDAR_PERIODS DP,
6285: FA_FISCAL_YEAR FY
6286: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6287: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6288: and TH.asset_id = p_member_asset_id
6386: end if;
6387:
6388: select DP.end_date into h_transaction_date
6389: from FA_FISCAL_YEAR FY,
6390: FA_CALENDAR_PERIODS DP
6391: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6392: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6393: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6394: and FY.fiscal_year = p_fiscal_year
6655: end if;
6656:
6657: select DP.end_date into h_transaction_date
6658: from FA_FISCAL_YEAR FY,
6659: FA_CALENDAR_PERIODS DP
6660: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6661: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6662: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6663: and FY.fiscal_year = p_fiscal_year
6984: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is
6985: select TH.TRANSACTION_HEADER_ID
6986: from FA_TRANSACTION_HEADERS TH,
6987: FA_FISCAL_YEAR FY,
6988: FA_CALENDAR_PERIODS DP
6989: where DP.calendar_type = h_calendar_type
6990: and DP.period_num = p_period_num
6991: and FY.fiscal_year_name = h_fiscal_year_name
6992: and FY.fiscal_year = p_fiscal_year
7043: and bk.depreciate_flag = 'YES'
7044: and exists
7045: (select TH1.TRANSACTION_HEADER_ID
7046: from FA_TRANSACTION_HEADERS TH1,
7047: FA_CALENDAR_PERIODS DP1,
7048: FA_FISCAL_YEAR FY
7049: where TH1.book_type_code = BK.book_type_code
7050: and DP1.calendar_type = h_calendar_type
7051: and DP1.period_num = p_period_num
7067: and bk.depreciate_flag = 'YES'
7068: and exists
7069: (select TH1.TRANSACTION_HEADER_ID
7070: from FA_TRANSACTION_HEADERS TH1,
7071: FA_CALENDAR_PERIODS DP1,
7072: FA_FISCAL_YEAR FY
7073: where TH1.book_type_code = BK.book_type_code
7074: and DP1.calendar_type = h_calendar_type
7075: and DP1.period_num = p_period_num
8325: cursor GET_FY_PERDNUM(p_date date) is
8326: select FY.fiscal_year,
8327: DP.period_num
8328: from fa_fiscal_year FY,
8329: fa_calendar_periods DP
8330: where FY.fiscal_year_name = h_fiscal_year_name
8331: and DP.calendar_type = h_deprn_calendar
8332: and DP.end_date <= FY.end_date
8333: and p_date >= DP.start_date
8344: and BK.group_asset_id = h_group_asset_id
8345: and exists
8346: (select TH1.TRANSACTION_HEADER_ID
8347: from FA_TRANSACTION_HEADERS TH1,
8348: FA_CALENDAR_PERIODS DP1,
8349: FA_FISCAL_YEAR FY
8350: where TH1.book_type_code = BK.book_type_code
8351: and DP1.calendar_type = h_deprn_calendar
8352: and DP1.period_num = p_period_num
8368: and BK.group_asset_id = h_group_asset_id
8369: and exists
8370: (select TH1.TRANSACTION_HEADER_ID
8371: from FA_TRANSACTION_HEADERS TH1,
8372: FA_CALENDAR_PERIODS DP1,
8373: FA_FISCAL_YEAR FY
8374: where TH1.book_type_code = BK.book_type_code
8375: and DP1.calendar_type = h_deprn_calendar
8376: and DP1.period_num = p_period_num
8393: and BK1.group_asset_id = h_group_asset_id
8394: and exists
8395: (select TH1.TRANSACTION_HEADER_ID
8396: from FA_TRANSACTION_HEADERS TH1,
8397: FA_CALENDAR_PERIODS DP1,
8398: FA_FISCAL_YEAR FY
8399: where TH1.book_type_code = BK1.book_type_code
8400: and TH1.asset_id = BK1.asset_id
8401: and DP1.calendar_type = h_deprn_calendar
8415: and BK1.group_asset_id <> h_group_asset_id
8416: and exists
8417: (select TH1.TRANSACTION_HEADER_ID
8418: from FA_TRANSACTION_HEADERS TH1,
8419: FA_CALENDAR_PERIODS DP1,
8420: FA_FISCAL_YEAR FY
8421: where TH1.book_type_code = BK1.book_type_code
8422: and TH1.asset_id = BK1.asset_id
8423: and DP1.calendar_type = h_deprn_calendar
8437: and BK1.group_asset_id = h_group_asset_id
8438: and exists
8439: (select TH1.TRANSACTION_HEADER_ID
8440: from FA_TRANSACTION_HEADERS TH1,
8441: FA_CALENDAR_PERIODS DP1,
8442: FA_FISCAL_YEAR FY
8443: where TH1.book_type_code = BK1.book_type_code
8444: and TH1.asset_id = BK1.asset_id
8445: and DP1.calendar_type = h_deprn_calendar
8459: and BK1.group_asset_id <> h_group_asset_id
8460: and exists
8461: (select TH1.TRANSACTION_HEADER_ID
8462: from FA_TRANSACTION_HEADERS TH1,
8463: FA_CALENDAR_PERIODS DP1,
8464: FA_FISCAL_YEAR FY
8465: where TH1.book_type_code = BK1.book_type_code
8466: and TH1.asset_id = BK1.asset_id
8467: and DP1.calendar_type = h_deprn_calendar
8497: --* Get all transaction headers exists in the specified period
8498: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number, p_member_asset_id number) is
8499: select TH.TRANSACTION_HEADER_ID, TH.TRANSACTION_TYPE_CODE
8500: from FA_TRANSACTION_HEADERS TH,
8501: FA_CALENDAR_PERIODS DP,
8502: FA_FISCAL_YEAR FY
8503: where DP.calendar_type = h_deprn_calendar
8504: and DP.period_num = p_period_num
8505: and FY.fiscal_year_name = h_fiscal_year_name
11312: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11313:
11314: select cp.period_name
11315: into h_period_name
11316: from fa_calendar_periods cp, fa_fiscal_year fy
11317: where cp.calendar_type = h_calendar_type and
11318: cp.period_num = p_period_num and
11319: cp.start_date >= fy.start_date and
11320: cp.end_date <= fy.end_date and