APPS.FA_REC_PVT_PKG1 dependencies on FA_RETIREMENTS

Line 132: FROM fa_retirements

128: END IF;
129:
130: /* Check if there is any pending retirements for the asset. */
131: SELECT count(1) INTO l_pending_retirements
132: FROM fa_retirements
133: WHERE asset_id = p_asset_id
134: AND status IN ('PENDING', 'REINSTATE')
135: AND rownum < 2;
136: