APPS.IGI_IMP_IAC_TRANSFER_PKG dependencies on FA_DEPRN_PERIODS

Line 161: FROM fa_books fab, fa_deprn_periods fdp

157: fab.life_in_months - floor(months_between(
158: fdp.CALENDAR_PERIOD_CLOSE_DATE,
159: fab.deprn_start_date)))
160: INTO l_remaining_periods
161: FROM fa_books fab, fa_deprn_periods fdp
162: WHERE fab.book_type_code = arec.book_type_code
163: AND fdp.book_type_code = arec.book_type_code
164: AND fab.asset_id = arec.asset_id
165: AND fab.date_ineffective is null

Line 179: FROM fa_deprn_periods

175: l_deprn_per_period_hist := arec.accum_deprn_hist / l_elapsed_periods;
176:
177: SELECT (period_num - 1)
178: INTO l_elapsed_periods_curr_yr
179: FROM fa_deprn_periods
180: WHERE book_type_code = arec.book_type_code
181: AND PERIOD_CLOSE_DATE IS NULL;
182:
183: IF (cumm_reval_rate > 1) THEN

Line 681: from fa_deprn_periods

677:
678: CURSOR C_Fa_Period_Counter
679: IS
680: SELECT max(period_counter)
681: from fa_deprn_periods
682: where book_type_code=p_book_type_code;
683:
684: CURSOR C_Imp_Period_Counter
685: IS

Line 694: fa_deprn_periods dp

690: CURSOR C_Trxn
691: IS
692: SELECT count(*)
693: FROM fa_transaction_headers ft ,
694: fa_deprn_periods dp
695: WHERE ft.book_type_Code = P_book_type_code
696: AND dp.book_type_Code = P_book_type_code
697: AND dp.period_close_Date IS NULL
698: AND ft.date_effective >= dp.period_open_date ;

Line 772: FROM fa_deprn_periods

768:
769: CURSOR C_fiscal_year(p_period_counter in NUMBER)
770: IS
771: SELECT fiscal_year
772: FROM fa_deprn_periods
773: WHERE book_type_code = p_book_type_code AND
774: period_counter = p_period_counter-1;
775:
776: CURSOR C_all_dist( p_fiscal_year in NUMBER)

Line 787: fa_deprn_periods dp

783: dh.code_combination_id,
784: dh.date_ineffective
785: FROM
786: fa_distribution_history dh,
787: fa_deprn_periods dp
788: WHERE
789: dh.asset_id= p_asset_id AND
790: dh.book_type_code=p_book_type_code AND
791: (nvl(dh.date_ineffective,dp.period_open_date)>=dp.period_open_date) AND

Line 795: FROM fa_deprn_periods

791: (nvl(dh.date_ineffective,dp.period_open_date)>=dp.period_open_date) AND
792: dp.Book_type_code=p_book_type_code AND
793: dp.fiscal_year=p_fiscal_year AND
794: dp.period_num=(SELECT min(period_num)
795: FROM fa_deprn_periods
796: WHERE fiscal_year=p_fiscal_year and
797: book_type_code=p_book_type_code);
798:
799: CURSOR C_period_counter

Line 809: FROM fa_deprn_periods dp,

805: CURSOR C_counter(p_distribution_id in number
806: ,p_fiscal_year in NUMBER)
807: IS
808: SELECT dp.period_counter
809: FROM fa_deprn_periods dp,
810: fa_distribution_history dh
811: WHERE (dh.date_ineffective between dp.period_open_date and dp.period_close_date) AND
812: dp.book_type_code=p_book_type_code AND
813: dp.fiscal_year=p_fiscal_year AND