57: return BOOLEAN is
58:
59:
60: h_amount_cleard NUMBER := 0;
61: h_book fa_book_controls.book_type_code%TYPE;
62: h_book_class fa_book_controls.book_class%TYPE;
63: h_dist_book fa_book_controls.distribution_source_book%TYPE;
64:
65: h_date_eff DATE;
58:
59:
60: h_amount_cleard NUMBER := 0;
61: h_book fa_book_controls.book_type_code%TYPE;
62: h_book_class fa_book_controls.book_class%TYPE;
63: h_dist_book fa_book_controls.distribution_source_book%TYPE;
64:
65: h_date_eff DATE;
66: h_msg_name VARCHAR2(30) := NULL;
59:
60: h_amount_cleard NUMBER := 0;
61: h_book fa_book_controls.book_type_code%TYPE;
62: h_book_class fa_book_controls.book_class%TYPE;
63: h_dist_book fa_book_controls.distribution_source_book%TYPE;
64:
65: h_date_eff DATE;
66: h_msg_name VARCHAR2(30) := NULL;
67: h_cur_per_ctr NUMBER;
1844: h_is_prior_period
1845: FROM
1846: FA_DEPRN_PERIODS DP_NOW,
1847: FA_DEPRN_PERIODS DP,
1848: FA_BOOK_CONTROLS BC,
1849: FA_TRANSACTION_HEADERS TH
1850: WHERE
1851: TH.ASSET_ID = X_asset_id AND
1852: TH.TRANSACTION_TYPE_CODE = DECODE(BC.BOOK_CLASS,'CORPORATE',