APPS.FA_RETIRE_PKG dependencies on FA_DEPRN_PERIODS

Line 86: fa_deprn_periods dp,

82: LV_Unit_Adjustment_Flag
83: FROM
84: fa_books bk,
85: fa_asset_history ah,
86: fa_deprn_periods dp,
87: fa_additions ad
88: WHERE
89: bk.book_type_code = X_Book_Type_Code and
90: bk.asset_id = X_Asset_Id and

Line 125: FA_DEPRN_PERIODS DP

121: -- Check when asset was added
122: SELECT dp.period_counter
123: INTO X_Asset_Added_PC
124: FROM FA_TRANSACTION_HEADERS TH,
125: FA_DEPRN_PERIODS DP
126: WHERE TH.ASSET_ID = X_ASSET_ID
127: AND TH.BOOK_TYPE_CODE = X_BOOK_TYPE_CODE
128: AND TH.TRANSACTION_TYPE_CODE||'' =
129: DECODE(X_Book_Class,'CORPORATE','TRANSFER IN', 'ADDITION')