APPS.FA_REC_PVT_PKG1 dependencies on FA_RETIREMENTS

Line 124: FROM fa_retirements

120: END IF;
121:
122: /* Check if there is any pending retirements for the asset. */
123: SELECT count(1) INTO l_pending_retirements
124: FROM fa_retirements
125: WHERE asset_id = p_asset_id
126: AND status IN ('PENDING', 'REINSTATE')
127: AND rownum < 2;
128: