DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on FA_DEPRN_PERIODS

Line 3098: from fa_deprn_periods fdp

3094:
3095: select GREATEST(fdp.calendar_period_open_date,
3096: LEAST(sysdate,fdp.calendar_period_close_date))
3097: into x_date_placed_in_service
3098: from fa_deprn_periods fdp
3099: where fdp.book_type_code = x_book_type_code
3100: and fdp.period_close_date is null;
3101:
3102: EXCEPTION

Line 3357: fa_deprn_periods fdp

3353: GREATEST(fdp.calendar_period_open_date,LEAST(sysdate,fdp.calendar_period_close_date))
3354: INTO
3355: l_amortization_start_date
3356: FROM
3357: fa_deprn_periods fdp
3358: WHERE
3359: fdp.book_type_code = x_book_type_code
3360: and fdp.period_close_date is null;
3361: EXCEPTION