DBA Data[Home] [Help]

APPS.FA_GAINLOSS_MIS_PKG dependencies on FA_DEPRN_PERIODS

Line 129: FROM fa_deprn_periods fadp

125: -- Get current period number
126:
127: SELECT fadp.period_num
128: INTO h_cpdnum
129: FROM fa_deprn_periods fadp
130: WHERE fadp.book_type_Code = h_book_type
131: AND fadp.period_name = h_cpdname;
132:
133: ret_p_jdate := to_char(ret_p_date, 'J');

Line 868: from fa_deprn_periods

864:
865: begin
866: SELECT h_date_retired
867: INTO h_ret_prorate_date
868: from fa_deprn_periods
869: where book_type_code = h_book
870: and period_close_date is null
871: and (h_ret_prorate_date < calendar_period_open_date or h_ret_prorate_date > calendar_period_close_date);
872: exception