109: -- FUNCTION Chk_Asset_Life: Find if the life of asset is completed in
110: -- the given period
111: -- -------------------------------------------------------------------
112: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
113: p_period_counter fa_deprn_periods.period_counter%TYPE,
114: p_asset_id fa_books.asset_id%TYPE,
115: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
116: )
117: RETURN BOOLEAN
111: -- -------------------------------------------------------------------
112: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
113: p_period_counter fa_deprn_periods.period_counter%TYPE,
114: p_asset_id fa_books.asset_id%TYPE,
115: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
116: )
117: RETURN BOOLEAN
118: IS
119:
244: WHERE fdd.distribution_id = cp_distribution_id
245: AND fdd.book_type_code = cp_book_type_code
246: AND fdd.asset_id = cp_asset_id
247: AND fdd.period_counter IN (SELECT period_counter
248: FROM fa_deprn_periods
249: WHERE book_type_code = cp_book_type_code
250: AND fiscal_year = (SELECT fiscal_year
251: FROM fa_deprn_periods
252: WHERE period_close_date IS NULL
247: AND fdd.period_counter IN (SELECT period_counter
248: FROM fa_deprn_periods
249: WHERE book_type_code = cp_book_type_code
250: AND fiscal_year = (SELECT fiscal_year
251: FROM fa_deprn_periods
252: WHERE period_close_date IS NULL
253: AND book_type_code = cp_book_type_code))
254: GROUP BY fdd.distribution_id;
255: