132: -- FUNCTION Chk_Asset_Life: Find if the life of asset is completed in
133: -- the given period
134: -- -------------------------------------------------------------------
135: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
136: p_period_counter fa_deprn_periods.period_counter%TYPE,
137: p_asset_id fa_books.asset_id%TYPE,
138: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
139: )
140: RETURN BOOLEAN
134: -- -------------------------------------------------------------------
135: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
136: p_period_counter fa_deprn_periods.period_counter%TYPE,
137: p_asset_id fa_books.asset_id%TYPE,
138: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
139: )
140: RETURN BOOLEAN
141: IS
142:
268: WHERE fdd.distribution_id = cp_distribution_id
269: AND fdd.book_type_code = cp_book_type_code
270: AND fdd.asset_id = cp_asset_id
271: AND fdd.period_counter IN (SELECT period_counter
272: FROM fa_deprn_periods
273: WHERE book_type_code = cp_book_type_code
274: AND fiscal_year = (SELECT fiscal_year
275: FROM fa_deprn_periods
276: WHERE period_close_date IS NULL
271: AND fdd.period_counter IN (SELECT period_counter
272: FROM fa_deprn_periods
273: WHERE book_type_code = cp_book_type_code
274: AND fiscal_year = (SELECT fiscal_year
275: FROM fa_deprn_periods
276: WHERE period_close_date IS NULL
277: AND book_type_code = cp_book_type_code))
278: GROUP BY fdd.distribution_id;
279: