APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_DEPRN_PERIODS

Line 916: CURSOR c_prior_period_counter(c_trx_date IN FA_DEPRN_PERIODS.period_open_date%TYPE)

912: AND transaction_header_id_out=p_trans_rec.transaction_header_id;
913:
914: -- Find period counter of transfer period in case of prior period transfer
915: -- (keep)
916: CURSOR c_prior_period_counter(c_trx_date IN FA_DEPRN_PERIODS.period_open_date%TYPE)
917: IS
918: SELECT period_counter
919: FROM fa_deprn_periods
920: WHERE c_trx_date BETWEEN period_open_date AND period_close_date

Line 919: FROM fa_deprn_periods

915: -- (keep)
916: CURSOR c_prior_period_counter(c_trx_date IN FA_DEPRN_PERIODS.period_open_date%TYPE)
917: IS
918: SELECT period_counter
919: FROM fa_deprn_periods
920: WHERE c_trx_date BETWEEN period_open_date AND period_close_date
921: AND book_type_code=p_asset_hdr_rec.book_type_code;
922:
923: -- find the total number of units for the asset itself ( active) (keep)

Line 941: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%TYPE)

937: AND book_type_code=p_asset_hdr_rec.book_type_code
938: AND transaction_header_id_in=p_trans_rec.transaction_header_id;
939:
940: -- select the start period number for a given fiscal year (keep)
941: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%TYPE)
942: IS
943: SELECT (number_per_fiscal_year*c_fiscal_year)+1
944: FROM fa_calendar_types
945: WHERE calendar_type=(SELECT deprn_calendar

Line 1017: l_current_period_counter fa_deprn_periods.period_counter%TYPE;

1013:
1014: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
1015: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1016: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1017: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1018: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1019: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;
1020: l_prd_rec igi_iac_types.prd_rec;
1021: l_prd_rec_prior igi_iac_types.prd_rec;

Line 1018: l_start_period_counter fa_deprn_periods.period_counter%TYPE;

1014: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
1015: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1016: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1017: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1018: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1019: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;
1020: l_prd_rec igi_iac_types.prd_rec;
1021: l_prd_rec_prior igi_iac_types.prd_rec;
1022: l_all_dist c_all_dist%ROWTYPE;

Line 1019: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;

1015: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1016: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1017: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1018: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1019: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;
1020: l_prd_rec igi_iac_types.prd_rec;
1021: l_prd_rec_prior igi_iac_types.prd_rec;
1022: l_all_dist c_all_dist%ROWTYPE;
1023: l_iac_dist c_iac_dist%ROWTYPE;