APPS.FARX_RP dependencies on FA_DEPRN_PERIODS

Line 1027: FROM FA_DEPRN_PERIODS dp,

1023: h_dpis DATE;
1024: -- Cursor to check whether the asset was added in the current open period.
1025: CURSOR added_this_period IS
1026: SELECT 'Y'
1027: FROM FA_DEPRN_PERIODS dp,
1028: FA_TRANSACTION_HEADERS th
1029: WHERE th.book_type_code = X_Book_Type_Code
1030: AND th.asset_id = X_Asset_Id
1031: AND th.transaction_type_code||'' in ('ADDITION', 'CIP ADDITION')

Line 1041: FROM FA_DEPRN_PERIODS dp

1037: -- Cursor to get transaction date entered.
1038: CURSOR get_trx_date_entered IS
1039: SELECT greatest(dp.calendar_period_open_date,
1040: least(trunc(sysdate), dp.calendar_period_close_date))
1041: FROM FA_DEPRN_PERIODS dp
1042: WHERE dp.book_type_code = X_Book_Type_Code
1043: AND dp.period_close_date is null;
1044: -- Cursor to get date placed in service.
1045: CURSOR get_dpis IS