DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on FA_DEPRN_PERIODS

Line 2765: from fa_deprn_periods fdp

2761:
2762: select GREATEST(fdp.calendar_period_open_date,
2763: LEAST(sysdate,fdp.calendar_period_close_date))
2764: into x_date_placed_in_service
2765: from fa_deprn_periods fdp
2766: where fdp.book_type_code = x_book_type_code
2767: and fdp.period_close_date is null;
2768:
2769: EXCEPTION

Line 2995: fa_deprn_periods fdp

2991: GREATEST(fdp.calendar_period_open_date,LEAST(sysdate,fdp.calendar_period_close_date))
2992: INTO
2993: l_amortization_start_date
2994: FROM
2995: fa_deprn_periods fdp
2996: WHERE
2997: fdp.book_type_code = x_book_type_code
2998: and fdp.period_close_date is null;
2999: EXCEPTION