APPS.IGIRX_C_IMP_IAC_REP dependencies on FA_DEPRN_PERIODS

Line 27: from fa_deprn_periods

23:
24: CURSOR C_Fa_Period_Counter
25: IS
26: SELECT max(period_counter)
27: from fa_deprn_periods
28: where book_type_code=p_dist_source_book;
29:
30: CURSOR C_Imp_Period_Counter
31: IS

Line 40: fa_deprn_periods dp

36: CURSOR C_Trxn
37: IS
38: SELECT count(*)
39: FROM fa_transaction_headers ft ,
40: fa_deprn_periods dp
41: WHERE ft.book_type_Code = p_dist_source_book
42: AND dp.book_type_Code = p_dist_source_book
43: AND dp.period_close_Date IS NULL
44: AND ft.date_effective >= dp.period_open_date ;