APPS.FARX_RP dependencies on FA_DEPRN_PERIODS

Line 998: FROM FA_DEPRN_PERIODS dp,

994: h_dpis DATE;
995: -- Cursor to check whether the asset was added in the current open period.
996: CURSOR added_this_period IS
997: SELECT 'Y'
998: FROM FA_DEPRN_PERIODS dp,
999: FA_TRANSACTION_HEADERS th
1000: WHERE th.book_type_code = X_Book_Type_Code
1001: AND th.asset_id = X_Asset_Id
1002: AND th.transaction_type_code||'' in ('ADDITION', 'CIP ADDITION')

Line 1011: FROM FA_DEPRN_PERIODS dp

1007: -- Cursor to get transaction date entered.
1008: CURSOR get_trx_date_entered IS
1009: SELECT greatest(dp.calendar_period_open_date,
1010: least(trunc(sysdate), dp.calendar_period_close_date))
1011: FROM FA_DEPRN_PERIODS dp
1012: WHERE dp.book_type_code = X_Book_Type_Code
1013: AND dp.period_close_date is null;
1014: -- Cursor to get date placed in service.
1015: CURSOR get_dpis IS