DBA Data[Home] [Help]

APPS.FA_TRANSFERS_PKG dependencies on FA_DEPRN_PERIODS

Line 56: from fa_deprn_periods

52: into X_Transaction_Date_Entered,
53: X_Calendar_Period_Open_Date,
54: X_Calendar_Period_Close_Date,
55: X_Current_PC
56: from fa_deprn_periods
57: where book_type_code = X_Book_Type_Code
58: and period_close_date is null;
59: --
60: select dp.period_counter

Line 62: from fa_deprn_periods dp, fa_transaction_headers th

58: and period_close_date is null;
59: --
60: select dp.period_counter
61: into X_Transfer_In_PC
62: from fa_deprn_periods dp, fa_transaction_headers th
63: where th.asset_id = X_Asset_Id
64: and th.book_type_code = X_Book_Type_Code
65: and th.transaction_type_code = 'TRANSFER IN'
66: and dp.book_type_code = X_Book_Type_Code

Line 168: fa_deprn_periods dp,

164: -- do this in the form, using INS_DETAIL
165: select count(1)
166: into lv_count
167: from fa_transaction_headers th,
168: fa_deprn_periods dp,
169: fa_book_controls bc
170: where bc.book_class <> 'CORPORATE'
171: and bc.distribution_source_book = X_Book_Type_Code
172: and th.book_type_code = bc.book_type_code